Post reply

SQL Server Memory Settings

  • June 25, 2011 at 8:12 am

    #239869

    Hi There,

    Do I need rememeber anything more while setting the SQL Server memory configuration for SQL SErver 2005?

    Generally if in the SQL Server, Biztalk and MOSS databases are available, do I need to recommend anything more to avoid any issues related to memory?

    Thanks.

  • June 25, 2011 at 12:22 pm

    #1344109

    Sourav-657741 (6/25/2011)

    Do I need rememeber anything more while setting the SQL Server memory configuration for SQL SErver 2005?

    Anything more than what?

    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

  • June 25, 2011 at 1:05 pm

    #1344120

    Hi Gail,

    I wanted to know how much will be proportion while setting SQL Server memory (Min and Max server memory configuration). Also, the SQL Server, where the MOSS and Biz databases are hosted whether in that scenario, I need to take up anything special activity while configuring the memory.

    Thanks.

  • June 25, 2011 at 1:12 pm

    #1344124

    Why not let SQL manage the memory on its own, are you using a 64 bit implementation ?

    At worst you might need enable the 3 gb switch in boot.ini and lock memory in pages option in the OS if your using 32 bit , else sql will manage memory as required.

    In SQL 2008 you have resource governor to allow limiting memory with more granularity.

    Jayanth Kurup[/url]

  • June 25, 2011 at 1:31 pm

    #1344135

    I knew that unless we allocate a specific amount of max server memory, SQL will try to capture the most if required and OS will suffer to get the requisite memory. But this is very much true in 32 Bit OS.

    What are the essential guidelines for 64 Bit OS?

    Thanks.

  • June 26, 2011 at 2:55 am

    #1344190

    Set the max memory low enough that there's enough free for the OS and any other apps on the server. There's no absolute rule with absolute formulas.

    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 6 posts - 1 through 5 (of 5 total)

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