October 22, 2008 at 11:47 pm
hi m having a server brand new server
with 28 GB ram and processor 3ghz * 2
database size 10 GB
when i run sp_configure for max server memory i get this values
config value for sqlserver i think is to high wat are ur suggestions
name minimum maximum config_value run_value
----------------------------------- ----------- ----------- ------------ -----------
max server memory (MB) 16 2147483647 2147483647 2147483647
October 23, 2008 at 5:13 am
If your server is only running SQL Server and has no other resource intensive apps running on it reserving 2GB RAM for the OS should be plenty. Therefore, set your maximum memory to 26GB (or 26624MB).
I never bother setting the minimum, but then I don't run multiple instances or other memory intensive apps on my SQL servers. If you do, you may want to consider some monitoring of process | private bytes (in perfmon or process explorer) which indicates the amount of non shared memory reserved by any given process. Then setting a different max for each instance, or a minimum and a max.
October 23, 2008 at 7:59 am
Hi,
Are you running a 32 or 64 bit OS/SQL Server combination? Related to your question but not answering it directly. (That was already done)
If you're using 32 bit, you will need to enable the 3GB switch in your boot.ini file as well as AWE to take advantage of any memory over 2 GB.
Chris.
Chris.
October 23, 2008 at 11:10 pm
m using x64 so i think that is not needed..
October 24, 2008 at 12:14 pm
Hi,
Our production server has 4Gb Physical memory
2 x Quad Core Cpu 2.6Mhz
Main database : approx. 1Gb with low load for the moment (busy migrating old application to sqlserver en windev forehand)
I have enabled the /3Gb switch in de boot.ini file but do i also have to enable AWE .?
If so: are there any other setting that should been taken care of .?
Currently sqlserver.exe runs up to 2.2Gb memory usage in taskmanager
Responds from server are lightning fast (but then again, im mostly running in max 5 simultanious users for the moment, will go up to approx. 100 users (batch processing included)
Tnx for any advice regarding this "issue"
wkr
Eddy
October 24, 2008 at 12:25 pm
By default SQL Server reserve 2 Gb for maximum memory, you have to increase it to your prefered value if there is one lne instance and ther is no other application running on server then 26 gb can be allocated to SQL Server, as it is 64 bit you need not AWE ,/pae. or /3gb switch.
increase the maximum memory setting and restart the SQL Server..
HWH
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply