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.
