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

ID: Q166337

The information in this article applies to:

Microsoft SQL Server version 6.5

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:

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

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