[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3464
  • 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

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