August 12, 2014 at 4:51 am
Hi all,
application is getting slow during morning time for half an hour. Client has sent mail during evning time saying , they are getting slowness issue during particular time. Is it possible to check in evening time , why its slow between 10:30 AM to 11:00 AM.
Thanks
August 12, 2014 at 5:01 am
There are some things you can check. Do any batch processes, backups or database maintenance run during the slow period? You can query your plan cache for the longest running queries, assuming they haven't been recompiled since the slow period. You'll want to set up some monitoring so that you can react to questions like this more easily. If you capture performance counters, wait stats and all sorts of other things , you can see what looked out of the ordinary the next time someone tells you the application has ground to a halt.
John
August 12, 2014 at 5:12 am
A little old, but still mostly valid
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply