September 28, 2015 at 8:46 am
Hello,
We are supporting one of the client and they are facing slowness from last couple of weeks at a specific time. I have setup the sql profiler but not couldnt find anything unusual. I did check error-logs and it seems perfectly fine. No jobs running during that time.
Am i missing anything? Any input will be greatly appreciate.
Thanks a lot for your help in advance.
September 28, 2015 at 9:40 am
Unless you change the hardware, a database server will always run at the same speed. However, individual process typically sprint, stop and wait, sprint, stop and wait, etc. It stops to wait for disk read or write operations to complete, it waits for remote procedure calls, it waits for locks to be released, etc. So, you need to analyze wait states during the period of time that the server appears not be getting as much work done. Determine what is waiting and why.
https://support.microsoft.com/en-us/kb/271509
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply