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