Microsoft KB Archive/106010

FIX: Error 816 When Many Updates Performed

PSS ID Number: Q106010 Article last modified on 10-31-1994

4.20

WINDOWS

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.