• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3479
  • Last Modified:

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
0
essentialdatasolutions
Asked:
essentialdatasolutions
  • 5
  • 3
1 Solution
 
arbertCommented:
Any backups or scheduled jobs running?  
0
 
essentialdatasolutionsAuthor Commented:
No backups or scheduled jobs are running.
0
 
arbertCommented:
Is this process using a paralell plan?  Multiple ECIDs for the SPID you're looking at?
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
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
 
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
 
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now