August 10, 2011 at 1:23 pm
SQL 2005 Ent. Edition - 64 Bit (9.00.4035)
Running on Win 2008 R2 - 64 Bit
64 GB of Ram
SQL Configuration: 58000 MB (Max)
When we had 32 GB RAM we never got "There is insufficient system memory to run this query." error now after upgrading RAM we are experiencing issues...quite strange!
also, at times SQL Services would restart on its own.
Thought of checking with the gurus out here to see if we are missing anything.
Lock Pages in Memory -- is this an option worth trying?
------------
Below are from SQL Error Logs:
Warning: The available page file space has dropped below 4Mb.
..
..
There is insufficient system memory to run this query.
Error: 701, Severity: 17, State: 123.
..
..
Process physical/virtual memory pressure: 0/0 System physical memory pressure: 0
..
..
Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 65536
August 10, 2011 at 1:55 pm
Please don't cross post. It fragments replies and waste everybody's time.
No more repllies please, continue the discussion here : http://www.sqlservercentral.com/Forums/Topic1157732-149-1.aspx
August 10, 2011 at 2:02 pm
sorry...i thought this would be an appropriate forum, that is why i changed to this forum
August 10, 2011 at 2:06 pm
NP, you'll get both now.
😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply