November 30, 2010 at 10:18 am
Hi,
We have performance issue on one of our prod servers.
it has 8GB of RAM on it and running SQL server 2005.
for SQL server 2005, the memory settings are : Minimum Server Memory: 128MB
Maximum Server Memory: 4096 MB
Minimum memory per query is set to 1024 KB.
Checked the SQL server log and found the following errors:
spid60 Error: 701, Severity: 17, State: 123
spid60 There is insufficient system memory to run this query.
Please help!
November 30, 2010 at 1:51 pm
The error is regarding virtual memory, try modifying the virtual memory on the server in Computer Management.
Good luck
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
November 30, 2010 at 2:17 pm
Hi,
I checked the virtual memory settings and found the following.
Initial size - 4096MB
Maximum size - 4096MB
Total paging file size for all drives - 34080MB.
I think this setting is fine.
Please advise.
November 30, 2010 at 2:20 pm
Please review the following Microsoft article on virtual memory size
http://support.microsoft.com/kb/889654
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
November 30, 2010 at 2:23 pm
Page file != Virtual memory.
32 bit SQL? Have you changed the -g startup switch?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 1, 2010 at 12:01 pm
Yes, its 32bit SQL.
can u tell me how to do the switch?
June 1, 2011 at 11:21 am
Based on your setup, as a start, I would set my minimum and maximum SQL memory to 6GB, this leaves 2GB for your OS, then give the SQL Server service "Lock Pages in Memory" rights depending on the SP level.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply