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.