I've found this error in our SQL log:
"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. Error: 1204, Severity: 19, State: 4."
From last 5 days this exception is coming in our staging SQL Server. There is no other process running still it is publishing error every night.
Select @@Version
Microsoft SQL Server 2014 - 12.0.4213.0 (X64) Jun 9 2015 12:06:16 Copyright
Microsoft Corporation Enterprise Evaluation Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)
Does anyone know how to fix this? How to diagnose such error and find who is real culprit for it.