October 26, 2010 at 5:37 pm
October 26, 2010 at 7:33 pm
Are you running SQL Server on x64 hardware?
Are you running an x64 version of SQL Server?
If so, have you set the max memory for all instances on that system?
If not, then you need to set the max memory to at least 2GB less than the available memory on the server. You might need to reduce that number even more, depending on how much memory you have and what other applications/software is running on the server.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 26, 2010 at 7:56 pm
pavan_srirangam (10/26/2010)
How do I release memory from all caches?
I ran out of memory on my server and I see lots of waits waiting on memory.
trace your system and find the reason(software issue or hardware issue) caused the long waiting. Usually, it can be solved by doing the performance tuning.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply