February 5, 2009 at 12:32 pm
Hi experts
We have production server (windows 2003) which maintains our employee profiles,punch reports,etc. We use sql server 2000 in it.
At times it shows very high cpu and memory usage by sqlservr.exe and server becomes very slow.
Can you direct me how to go about for resolving this issue.
Tanx 😀
February 5, 2009 at 1:53 pm
If there are some specific times during the day that this runs, I would schedule a trace to run (or just open profiler and see what all is running when that time is coming) during that time of day.
If you happen to be online when the "slowness" is happening, view what all processes are active in sysprocesses (sp_who2). See which ones are using the most resources (CPU, IO, etc...) and then try to tune whatever queries or stored procedures those might be.
That is probably the easiest beginner method of determining what on SQL is running that is causing slow downs on the server.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply