Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kshahzad
Starting Member
45 Posts |
 Posted - 2013-07-05 : 09:20:33
|
| In one of our database, there is a stat about the whole day : SQL CPU Usage spikes b/w 8AM & 6PM is 5 spikes - highest is 30% @ 3:52PM; longest b/w 29 to 30% b/w 3:52PM to 3:56PM – spike occurs same time every dayso i want to find out how to check on whats going wroing during after noon when its slowest? |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-07-05 : 09:53:18
|
| First check with the DBA if there are any backup jobs, index rebuilds, stat updates etc. that are scheduled during those time slots.Check with sysadmins to see what they might be doing at those time slots.If none of that gives you any clue, see what queries are running at that time. See this blog for a query to see the most resource intensive queries: http://blog.sqlauthority.com/2010/05/14/sql-server-find-most-expensive-queries-using-dmv/ |
 |
|
|
kshahzad
Starting Member
45 Posts |
Posted - 2013-07-05 : 10:26:31
|
| THanks James,But how can i put the time range when running that query in blog |
|
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-07-05 : 10:42:50
|
| I meant to say that you should run those queries when you see the spiking. If you want to capture the queries and inspect them later, you will need to run trace or profiler. |
|
|
|
|
|
|
SQL Performance slow in afternoons only