September 17, 2004 at 12:17 am
On daily operations, sometime we do receive reports from users saying system slow for that period only. As an administrator, my action is use "sp_who" to find out if deadlock happen. Second thing is check "Memory Usage" in Enterprise Manager(Server Name>Management>Current Activity>Process Info). Is this an ideal practice? Anyone would like to share his experience?
September 17, 2004 at 12:32 am
You could also leave Profiler running and analyse the resulting trace around the 'slow' times to see whether you can identify what is causing the slowness (and therefore whether you can do something about it).
September 17, 2004 at 9:37 am
Run the trace from a remote server so that you can take off some load from the server.
September 17, 2004 at 9:49 am
Profiler is probably your best bet.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply