Top menu

"The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Return your statement when there are fewer user. Ask the database administrator" error in DeviceLock Enterprise Server Log

DESCRIPTION

DeviceLock Enterprise Server Log contains multiple errors "CALL DLLastAuditRecordTime(?,?)}:[Microsoft][ODBC SQL Driver][SQL Server] The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Return your statement when there are fewer user. Ask the database administrator".

COMMENTS

The errors indicate that SQL Server cannot obtain a lock resource. This can be caused by either of the following reasons:
- SQL Server cannot allocate more memory from the operating system, either because other processes are using it, or because the server is operating with the max server memory option configured.
-The lock manager will not use more than 60 percent of the memory available to SQL Server.

RECOMMENDATIONS

to resolve the issue, please refer to this Microsoft article: http://msdn.microsoft.com/en-us/library/aa337440.aspx