BUG: Error 816 Occurs When Many Updates Performed
PSS ID Number: Q105379
Article last modified on 06-21-1994

4.20

WINDOWS


----------------------------------------------------------------------
The information in this article applies to:

  - Microsoft SQL Server version 4.2 for Windows NT
----------------------------------------------------------------------

BUG# NT: 513 (4.2)

SYMPTOMS
========

When there are many updates performed in a database configured with low
open objects, SQL Server will give error 816, level 20, state 4:

   Process %d tried to remove a buffer resource lock %S_BUF that it
   does not hold in SDES %S_SDES. The SQL Server is terminating this
   process.

It also comes with the following two warnings:

   pss found with open sdes

and

  process being freed while holding Dataserver semaphore

In some cases, after cycling SQL Server, any attempt to create or drop a
table in the database will result in a 816 error and then being
disconnected. This usually occurs if the server is configured with a low
'open objects' (100). While, the error 816 happens when the tran log is
full and several 'dump tran with no_log' are issued.

WORKAROUND
==========

Increase the configuration for open objects.

STATUS
======

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

Additional reference words: 4.20 4.20a configuration 816 sdes

=============================================================================

Copyright Microsoft Corporation 1994.
