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


The information in this article applies to:

  • Microsoft SQL Server 6.5
This article was previously published under Q166337
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.
Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbbug kbfix kbusage KB166337
©2003 Microsoft Corporation. All rights reserved.