Post reply

How much memory should be allocated to SQL Server ?

  • February 24, 2010 at 12:47 am

    #139040

    Dear All,

    I have a dedicated server for SQL server database.

    It has got 16 GB memory, windows server 2003.

    SQL server 2005 64 bit with SP3.

    Database size is 260GB

    There is no any other application which needs any considerable amount of memory.

    Approximately 125 users will be accessing SQL server simaltaneously.

    So, Idealy, how much memory should I allocate to SQL Server ?

    Thanks in advance.

  • February 24, 2010 at 1:22 am

    #1124142

    12-14 GB. No more (and I'd err on the lower end of that). OS needs memory to manage memory, not good to starve it.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 24, 2010 at 1:42 am

    #1124152

    Thanks,

    At present only 4GB is allocated. Sometimes application runs very very slow.

  • February 24, 2010 at 3:07 am

    #1124177

    Joy Smith San (2/24/2010)

    Sometimes application runs very very slow.

    That isn't necessarily insufficient memory. Yes, memory may help, but you should also look at what's running and see what needs fixing/changing to make it run better.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply