With logshipping, I would alternate the schedules because I have seen
poor performance when trying to do them all at once. Although it all
depends on how many databases you are backing up transaction logs and
shipping.
I would turn on performance monitor on the server and measure disk queue
lengths. Also, make sure you regularly update statistics and once in a
while rebuild the indexes.
Try using this website http://www.sql-server-performance.com/
Rich
-----Original Message-----
From: benbart
[mailto:mssqldba-ezmlmshield-x99906650.[Email address protected]
Sent: Thursday, June 29, 2006 6:36 PM
To: LazyDBA Discussion
Subject: SQLServer Performance ...
Hi all,
Server have 2GB of memory, at the moment, SQLServer is using 1.7GB and
the rest is used by the OS, I presumed. Users complaining that the
database seems to be slow. Can someone please advise where to start
looking?
There is no error on the SQLSERVER LOGS. Transaction backup runs every
15 minutes, and log-shipping runs every 1 minute. These aren't my
settings so I do not want to take control straight away without any
evidence that changing the timings on these may lessen the load on the
server somehow.
Looking at Current Activity - Process Info, does a high number Memory
Usage means this process is using the most memory, in MB? Does the same
logic applies for CPU and Physical IO, i.e., the higher the number, the
more job or task that connection is doing? Are all these figures
irrelevant if Wait Type is not waiting, Wait Time is 0 (zero) and status
is sleeping? Checked the Properties, most of them seems to say
sp_unprepare and SELECTs
Anyway, can someone please advise a good procedure on how to
troubleshoot SQLServer Performance Issues. SQLServer version is
SQLServer Enterprise Edition 2000.
Thanks in advance.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
The information contained in this electronic message is for the exclusive and confidential use of the addressee. Any other distribution, use, reproduction or alteration of the information contained in this electronic message, by the addressee or by any other recipient, without the prior written consent of the sender is strictly prohibited. If you have received this electronic message in error, please notify the sender.
MS Sql Server LazyDBA home page