Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

cpu peaks and -1 spids Expand / Collapse
Author
Message
Posted Thursday, December 12, 2013 10:58 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 1:07 PM
Points: 83, Visits: 209
Hi,
I am viewing the activity monitor and I see every 10-20 seconds the cpu goes from 2% to 80-90%.
I have tried to see if there are any blocks using sp_who3 (http://sqlserverplanet.com/dba/a-better-sp_who2-using-dmvs-sp_who3).
I saw a -1 spid and cant seem to find anything on google.

But the real question is, how can I track down the process that is causing the cpu processor to peak.

Sql server 2005 , 64gm memory and I see at least 31 cpu proccessors on it.

Thanks!
Post #1522420
Posted Monday, December 16, 2013 1:50 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 1:54 PM
Points: 271, Visits: 1,104
Did you tried tracking it down to what that spid was actually doing using DMV's or any other traces? Did you already tried that and found nothing useful?

Go through this post from Paul...Hope this helps.
http://www.sqlskills.com/blogs/paul/disaster-recovery-101-dealing-with-negative-spids-2-and-3/
Post #1523423
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse