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

SYMPTOMS

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.