Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Unanswered: What is a MISCELLANEOUS lock?

    My server is running an important stored proc.

    The system is reporting very low CPU and disk use, and there is no important network activity (all relevant data is local). In Enterprise Manager, my process is listed as sleeping with a "wait type" of "miscellaneous". What could this possibly mean? How can I diagnose?

  2. #2
    Join Date
    Apr 2004
    Kansas City, MO
    If you know the SPID, set up a Profiler trace to track filtered on trace. Track all SP:Batch Started, SP:Batch Completed, SPtmt Started, SPtmt Completed, RPCtarted, RPC:Complted.

    Make sure you filter on SPID.

    Secondly, run DBCC INPUTBUFFER('spid') to make sure it's still running.
    When life gives you a lemon, fire the DBA.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts