BUG: Concurrent Async Keyset Cursors can Result in Server Hang

ID: Q226191

The information in this article applies to:

Microsoft SQL Server version 7.0

BUG #: 55020 (SQLBUG_70)

SYMPTOMS

If all worker threads in SQL Server are executing commands for keyset cursors that are being populated asynchronously, the server hangs. The server will then not allow any new connections or other existing queries to execute.

WORKAROUND

Disable asynchronous keyset cursors by changing the cursor threshold configuration value to -1 (which is the default) or reduce the number of concurrent users executing asynchronous keyset cursors.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0.

Additional query words:

Keywords : kbbug7.00 kbSQLServ700bug
Version : winnt:7.0
Platform : winnt
Issue type : kbbug