Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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... Expand / Collapse
Author
Message
Posted Wednesday, May 15, 2013 5:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 10, 2014 3:05 AM
Points: 3, Visits: 15
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
Post #1453017
Posted Wednesday, May 15, 2013 8:43 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 9:30 AM
Points: 509, Visits: 1,885
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 .
Post #1453140
Posted Wednesday, May 15, 2013 9:41 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 2:32 AM
Points: 20,807, Visits: 32,740
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.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1453190
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse