Warren Peace (8/7/2009)
Richard, thanks for the vlidation. I know this has always been cunfusing, that's why I raised the question of it.lol, why the hell does MS leave in there then?......lol :hehe:
They leave it in there because that is part of the client-tool which is, of course, used to manage both 64 bit and 32bit systems.
There have been many reports about SQL Server 2005 Standard Edition on x64 paging out memory and memory pressure. What most people have found is that you have to drop the max memory setting quite a bit to relieve these issues. Some have been able to set it as high as 13GB (on 16GB machines) with no problems. Most, however, have not been able to go above 12GB without issues.
I was running Standard Edition on a machine with 32GB of memory. I could not go above 24GB allocated to SQL Server without having memory issues.
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