SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SQL service terminated due to ran out of memory
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

litudeb
Starting Member

1 Posts

Posted - 04/04/2014 :  07:44:15  Show Profile  Reply with Quote
The SQL Server service terminated with the following error:
Ran out of memory.Please help to fix this..

OS details: windows 2008 enterprise
SQL Vesrion: sqlserver 2005 standered edition
Service pack: sp4

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>]

tkizer
Almighty SQL Goddess

USA
37466 Posts

Posted - 04/04/2014 :  16:29:59  Show Profile  Visit tkizer's Homepage  Reply with Quote
Looks like you've got a hardware resource issue. You need to take a look at your queries as well as your hardware.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2079 Posts

Posted - 04/09/2014 :  01:47:12  Show Profile  Visit jackv's Homepage  Reply with Quote
To find the cause requires to search for a memoryclerk or cachestore which consumes the highest memory.

First step is to identify which memoryclerk or cachestore is consuming the highest memory.When you inspect the Error Logs , there is normally the DBCC memorystatus output.
There is some more information on :http://www.sqlserver-dba.com/2012/11/sql-server-error-701-there-is-insufficient-system-memory.html
for troubleshooting error 701

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

Shanky
Yak Posting Veteran

United Kingdom
84 Posts

Posted - 07/09/2014 :  07:28:19  Show Profile  Reply with Quote
Hi,
This seems to me like resource contention issue. What was the query running when you got this message. Can you post output of DBCC MEMORYSTATUS command for analysis. IMO this error occured because there are not enough system locks to complete the current command and this could be because system had very low memory. Locks require memory and every lock has some memory associated with it.

Regards
Shanky
http://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000