healthcheckinc
asked on
Sqlservr.exe memory usage issues
I am running SQL Server 2005 on windows 2000 server machine with 16gb of ram. What would be my most efficient memory settings because I am getting serious sqlservr.exe memory spikes. Dont know if this will resolve the problem but I want to make sure I cover my back as far as my settings...
When upgrading OS, choose the enterprice ed. Quote from link above:
'Windows Server 2003, Enterprise Edition supports 32 GB of physical Memory'
/Marten
'Windows Server 2003, Enterprise Edition supports 32 GB of physical Memory'
/Marten
ASKER
I guess I should have included that it is a Windows 2003 R2 Enterprise Edition SP2....Sorry about that...Knowing that what would be your recommendations on Max - Min memory settings
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks
'With Windows 2000 Professional and Server, the maximum amount of memory that can be supported is 4 GB'
'Windows 2000 Advanced Server supports 8 GB of physical RAM and Windows 2000 Datacenter Server supports 32 GB of physical RAM'
Link: http://www.microsoft.com/whdc/system/platform/server/PAE/PAEmem.mspx
These are OS limitations. I guess you need to upgrade the OS to W2k3 R2 to use all unless you have the w2000 datacenter edition (not sold seperately).
/Marten