configuration

  • 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

  • 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.

  • 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.

  • m using x64 so i think that is not needed..

  • 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

  • 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