April 24, 2009 at 10:30 pm
Hi,
Sql server 2000 running very slow, that time i restarted SQL services after that running normally.
Could suggestion me what is the exact problem and what needs to check out?
Thanks
April 24, 2009 at 11:51 pm
Hi
There are many things you need to check to find out the reason. Without going into them i suggest you look up this site and other sql server sites and start the process.
When you come up with something ask us.
If you have no idea as to what could be a probable reason you can start a trace. Keep in mind that trace uses some resources, so be carefull while running it in your production system.
"Keep Trying"
April 25, 2009 at 10:33 am
First thing, if this has only just started happening, anyone changed anything?
if it happens again run sp_who2, look for blocking, and check what the most common wait types are.
run a perfmon (system monitor) counter log checking memory, i/o and cpu
buffer cache hit ratio
page life expectancy
processor %
disk read and write q lengths (per disk)
avg disk sec\write and disk sec\read
memory\available mbytes
total sql server memory
target sql server memory
batches \sec
compiles and recompiles\sec
run profiler, start off with the duration template, filtering on say queries taking longer than 3 secs. You might have to tune that depending on what results you get.
You might get lucky and it turns out you are just missing some indexes causing a lot of table scanning, or even indexes have become fragmented so query optimiser is no longer using them, So its worth checking your database is healthy up front (stats up to date, low levels of fragmentation)
---------------------------------------------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply