Microsoft KB Archive/166337

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

Article ID: 166337

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



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.



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: kbbug kbfix kbusage KB166337

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.