DEFWAKEUP status in sysprocesses with waittype = 0x0000

I am getting DEFWAKEUP status in sysprocesses which tells me that the SPID is waiting on a resource, yet the waittype = 0x0000 and the lastwaittype = MISCELLANEOUS.

Any clue about what the SPID is waiting on?

Thanks,
Rick
essentialdatasolutionsAsked:
Who is Participating?
 
arbertCommented:
Ok, that's what it is then....

Is this a query you can run in analyzer?  If so, run the query and at the end add

option(maxdop 1)


See if you notice any difference.  However, the waits are just a nature of the parallel plans.
0
 
arbertCommented:
Any backups or scheduled jobs running?  
0
 
essentialdatasolutionsAuthor Commented:
No backups or scheduled jobs are running.
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
arbertCommented:
Is this process using a paralell plan?  Multiple ECIDs for the SPID you're looking at?
0
 
arbertCommented:
Usually on a parallel plan, you'll see a CXPacket wait.  HOWEVER, you can also see a defwakeup if one of the threads happen to be contending with another thread of the same process.
0
 
essentialdatasolutionsAuthor Commented:
It is a parallel plan with Multiple ECIDs
0
 
essentialdatasolutionsAuthor Commented:
The query is a stored proc that is rather complex with nested procs and some cursors.  Earlier I wanted to add the maxdop 1 to take out the parallelism but this would involve adding it to several dozen queries.  I decided to investigate the DEFWAKEUP without a waittype first.

Thanks,
Rick
0
 
arbertCommented:
You can also go into the server properties and up the value used to figure out when to use paralellism....
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.