FIX: Issuing KILL on Running SQL Web Task Stops SQL Server

Case 1

When a KILL statement is issued against a running SQL Web task, SQL Server stops.

Case 2

Under stress testing using Microsoft SQL Server version 6.5 Service Pack 3 (SP3) and later, the Web Assistant may cause the SQL Server process to terminate. This occurs when sp_makewebtask and other Web Assistant stored procedures are running simultaneously. The error handler in the Web Assistant forces an EXIT Process and subsequently causes the SQL Server process to be exited.

This means that SQL Server will be shut down whenever dbopen fails in WebGetBoundConnection. Dbopen can fail simply because the server is too busy to accept additional connections.

This problem occurs when you are running a workload with many connections and many Web Assistant extended procedure calls on a system that lacks sufficient resources.

Code in the error handler returns a value of INT_EXIT when the connection is lost.

There is currently no workaround available for this problem.

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