monitor
#monitor#1203

1203

Product Name Event ID 1203 Event Source MSSQLSERVER Component SQLEngine S

Product

Name

Event ID

1203

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

LK_NOT

Message

Text

Process ID %d attempted to unlock a resource it does not own: %.*ls. Retry the

transaction, because this error may be caused by a timing condition. If the problem

persists, contact the database administrator.

This error occurs when SQL Server is engaged in some activity other than ordinary post-

processing cleanup and it finds that a particular page that it is trying to unlock is already

unlocked.

The underlying cause of this error may be related to structural problems within the affected

database. SQL Server manages the acquisition and release of pages to maintain concurrency

control in the multiuser environment. This mechanism is maintained by using various internal

lock structures that identify the page and the type of lock present. Locks are acquired for

processing of affected pages and released when the processing is finished.

Expand table