SQL Server Performance

The SQL Server service terminated with the following error :Ran out of memory

Discussion in 'ALL SQL SERVER QUESTIONS' started by litu.deb, Apr 2, 2014.

  1. litu.deb Member

    Before terminating sql services I got below error message in sqlserver error logs:How to fix this?

    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: 17138, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
    Error: 1204, Severity: 19, State: 4.
    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.
    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.
    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: 19032, Severity: 10, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
    Error: 701, Severity: 17, State: 123.
    There is insufficient system memory to run this query.
    Error: 17188, Severity: 16, State: 1.
    SQL Server cannot accept new connections, because it is shutting down. The connection has been closed. [CLIENT: <local machine>]

Share This Page