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.

Question

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.

ssandeepksh

SSC Journeyman

Points: 91
More actions
May 15, 2013 at 5:11 am

#394780

I am using MSQL 2008 R2. I am getting the below error
"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."
RAM is 64 GB and general properties of sql instance is showing 65536 MB (64 GB) under memory and MIN & MAX memory settings are default (0 & 2147483647) in SQL server.
Please help me to resolve this issue.
Thanks,
Sandeep

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 1

I don't mean this rudely but the text of the error message gives you quite a lot to be going on with, there. Are there any long-running transactions that might be preventing the lock?

Also not meant rudely, but I'd Google that error message if I were you. Perhaps the problem has resolved itself by now though :-).

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

ssandeepksh (5/15/2013)
I am using MSQL 2008 R2. I am getting the below error
"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."
RAM is 64 GB and general properties of sql instance is showing 65536 MB (64 GB) under memory and MIN & MAX memory settings are default (0 & 2147483647) in SQL server.
Please help me to resolve this issue.
Thanks,
Sandeep

You may also want to take a closer look at your MAX memory setting. As it currently sits you could easily starve the OS of memory. You may want to change it to 61440 MB as that should leave your OS with about 4 GB.