October 7, 2013 at 2:47 am
Hi,
We have sql 2005 running on win 2003 ,user getting error as '" There is insufficient system memory to run this query".
Ram is 4GB and sql is assigned to max 2.4 GB and Min 1 GB
AT presnt CPU and Memory is looking normal.
I have connected to server and there is no blockings and tried to connect the error log but got error as below,( XP-readerrorlog)
Msg 22004, Level 16, State 1, Line 0
Failed to open loopback connection. Please see event log for more information.
Msg 22004, Level 16, State 1, Line 0
error log location not found
Then i have cheked eventvwer an found below error.
1)
The description for Event ID ( 17052 ) in Source ( MSSQLSERVER ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Severity: 16 Error:8, OS: 8 [Microsoft][SQL Native Client]SQL Network Interfaces: Not enough storage is available to process this command.
.
2)There is insufficient system memory to run this query.
any help is much appricated...
THanks in advance..
October 7, 2013 at 6:21 am
2gb is a VERY small amount of memory for SQL Server. How much data are you trying to retrieve? How big is the query? The message you're receiving is very specific, there is not enough memory to process what you're requesting. So, the question is, what are you requesting.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply