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.




MS Sql Server LazyDBA home page