Grace09
SSCommitted
Points: 1532
More actions
June 12, 2015 at 8:49 am
#318197
SQL Server 2008 R2 SP2, the cpu spikes, but I can't find out which process causes it. Thanks in advance.
Shawn Melton
SSC-Insane
Points: 24675
June 12, 2015 at 8:53 am
#1805082
Open "perfmon /sys" from the run prompt.
Add the
/Process (sqlservr.exe)/% privileged and /% processor
/Processor time for the same objects
It will at least tell you if it is SQL Server.
Shawn Melton Twitter: @wsmelton Blog: wsmelton.github.com Github: wsmelton
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply