Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/105379

From BetaArchive Wiki

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.