June 13, 2014 at 4:55 am
Hi Experts,
We are seeing CPU spikes at a particular time everyday and it last for 15 minutes?
How can i find the processes ran during that time,jobs ?
What else i need to check
TIA
June 13, 2014 at 5:08 am
Server-side trace or extended events session
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
June 13, 2014 at 7:00 am
Thanks alot for the response.
Hope you meant to run server side trace during that particular time.
June 14, 2014 at 4:10 am
Both the server-side trace and extended events can be set up to run from a SQL Agent job so that they start at a particular time. Both can also be set to stop at a particular time either through the definition or by issuing a stop command, which you can schedule again through SQL Agent.
I favor extended events over trace because they have a significantly reduced footprint on the server. Since you're on 2012 you'll have a decent GUI for consuming the data generated, so the drawback of being forced to query the XML is eliminated.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply