Microsoft KB Archive/105379

BUG: Error 816 Occurs When Many Updates Performed PSS ID Number: Q105379 Article last modified on 06-21-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.

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.