FIX: Auto-Start Stored Procedure w/ WAITFOR Causes 100% CPU Use

ID: Q166337

The information in this article applies to:
BUG #: 16379 (WINDOWS: 6.5)

SYMPTOMS

The SQL Server service starts up and the % Total Processor Time Performance Monitor counter for the System object rapidly increases to 100 percent. The system appears to be very slow.


CAUSE

The auto-start stored procedure contains a WAITFOR statement.


WORKAROUND

To work around this problem, avoid having a WAITFOR statement in a startup stored procedure. Run the stored procedure using a query tool instead. Unmark the procedure as a startup procedure by doing the following:

  1. Start up SQL Server with the -f option to skip autoexec stored procedures and run in single-user mode.


  2. Open up a query window and run sp_unmakestartup <procedurename>.



STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider. 


Keywords          : kbusage SSrvGen SSrvStProc 
Version           : 6.5
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: April 9, 1999