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