1204

Product

Name

Event ID

1204

Event

Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

LK_OUTOF

Message

Text

The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this

time. Rerun your statement when there are fewer active users. Ask the database

administrator to check the lock and memory configuration for this instance, or to check

for long-running transactions.

During execution, queries frequently acquire and release locks on the resources they access.

Acquiring a lock uses up the lock structures from an available pool of lock structures. When

new locks can’t be acquired because there are no more lock structures available in the pool,

the error 1204 message is returned. This issue can be due to any of the following reasons:

can’t allocate more memory, either because other processes are using it, or

because SQL Server has used up all of its memory and reached the value configured using

the configuration option

max server memory.

The lock manager can’t use more than 60 percent of the memory available to SQL Server,

and the threshold has already been met.

You set up the configuration option

locks

of the system stored procedure

sp_configure

(Transact-SQL)

to a non-default, non-dynamic value.

ﾉ

Expand table