<div>
Any backups or scheduled jobs running? &nbsp;
</div>


Any backups or scheduled jobs running?  

<div>
No backups or scheduled jobs are running.
</div>


No backups or scheduled jobs are running.

<div>
Is this process using a paralell plan? &nbsp;Multiple ECIDs for the SPID you're looking at?
</div>


Is this process using a paralell plan?  Multiple ECIDs for the SPID you're looking at?

<div>
Usually on a parallel plan, you'll see a CXPacket wait. &nbsp;HOWEVER, you can also see a defwakeup if one of the threads happen to be contending with another thread of the same process.
</div>


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.

<div>
It is a parallel plan with Multiple ECIDs
</div>


It is a parallel plan with Multiple ECIDs

<div>
The query is a stored proc that is rather complex with nested procs and some cursors. &nbsp;Earlier I wanted to add the maxdop 1 to take out the parallelism but this would involve adding it to several dozen queries. &nbsp;I decided to investigate the DEFWAKEUP without a waittype first.<br />
<br />
Thanks,<br />
Rick
</div>


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

<div>
You can also go into the server properties and up the value used to figure out when to use paralellism....
</div>


You can also go into the server properties and up the value used to figure out when to use paralellism....

<div>
<div class="content wysiwyg-content">
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.<br />
<br />
Any clue about what the SPID is waiting on?<br />
<br />
Thanks,<br />
Rick
</div>
</div>


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

DEFWAKEUP status in sysprocesses with waittype = 0x0000

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.