DBCC WAKEUP

  • A co-worker just came to my desk and asked if I knew anything about DBCC WAKEUP.  I unfortunately do not.  It appears to be an undodumented DBCC command and I'm wondering if anyone might have any knowledge of this command.  The original thought was that it may be useful in a job we have that monitors blocking.

  • I think that this used to be used in Sybase to wake up a sleeping thread - it takes a SPID as an argument.  Whatever it used to do, it doesn't do anything now, apparently.  If you try to execute it (in SQL2K) you'll get this message:

    DBCC WAKEUP not implemented.
    DBCC execution completed. If DBCC printed error messages, contact your system administrator.

    A builtin way to get commands to execute repeatedly with a delay in between (if that's what you're trying to do) is to use a WHILE loop with a WAITFOR delay.

    Cheers,

    Chris

  • I was aware it existed but never have used so not sure of the impact but here are some others http://www.novicksoftware.com/TipsAndTricks/tip-sql-dbcc-help.htm

     

    Many are internal use only and undocumented.

  • You weren't dozing at your desk when your colleague mentioned this command to you?

    Antares - Cheers..That's a handy list

     

    Eoin

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply