FIX: Error 816 When Many Updates Performed
  
PSS ID Number: Q106010
Article last modified on 10-31-1994
 
4.20
 
WINDOWS
 

----------------------------------------------------------------------
The information in this article applies to:
 
  - Microsoft SQL Server version 4.2
----------------------------------------------------------------------
 
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.
 
The following warnings will also be received:
 
   pss found with open sdes
 
   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 be disconnected.
 
CAUSE
=====
 
The server is configured with a low configuration for open objects (100).
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 Microsoft SQL Server
version 4.2. This problem was corrected in SQL Server version 4.21. For
more information, contact your primary support provider.
 
Additional reference words: 4.20 configuration Windows NT
KBCategory: kbother kberrmsg
KBSubcategory: SSrvWinNT
 
=============================================================================
 
Copyright Microsoft Corporation 1994.
