BUG: Concurrent Cursors and St Procs Against Table May Cause AV

 Last reviewed: December 18, 1997
Article ID: Q178285
The information in this article applies to:
  • Microsoft SQL Server, version 6.5
BUG #: Windows NT: 17371 (6.5)

SYMPTOMS

Concurrent cursor and stored procedure access to the same table may result in a handled access violation (AV) and possibly cause the server to stop responding. The problem is specific to SQL Server running on a SMP computer.

WORKAROUND

To work around this problem, do either of the following:

  • Reduce the concurrency of cursor and stored procedure access to the same table.

    -or-

  • Increase the amount of memory for the procedure cache.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

This problem has only been observed when procedure cache is heavily used and is near its capacity. The client application may receive the following error before the AV: 

   Msg 701, "There is insufficient system memory to run this query."

Additional query words: hang hung freeze frozen lock locked up crash
crashed st proc stproc
Keywords : kbbug6.50
Version : WINNT:6.5
Platform : winnt
Issue type : kbbug
Solution Type : kbworkaround

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: December 18, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.