Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

configuration Expand / Collapse
Author
Message
Posted Wednesday, October 22, 2008 11:47 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, February 11, 2011 8:31 PM
Points: 297, Visits: 277
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

Post #590258
Posted Thursday, October 23, 2008 5:13 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, March 28, 2013 4:46 AM
Points: 963, Visits: 455
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.
Post #590375
Posted Thursday, October 23, 2008 7:59 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 8, 2014 3:23 PM
Points: 111, Visits: 348
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.
Post #590461
Posted Thursday, October 23, 2008 11:10 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, February 11, 2011 8:31 PM
Points: 297, Visits: 277
m using x64 so i think that is not needed..
Post #590974
Posted Friday, October 24, 2008 12:14 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, September 18, 2014 5:35 AM
Points: 647, Visits: 764
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
Post #591435
Posted Friday, October 24, 2008 12:25 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, November 13, 2014 8:40 AM
Points: 1,667, Visits: 1,381
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
Post #591441
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse