Post reply

SQl 2008 full RAM Utilizing

  • August 11, 2013 at 12:18 pm

    #395278

    Hello ,

    Using Sql 2008 R2 , have 16 Gb RAM . Did Sql will use whole memory ;if no another services using that memory .

    how we can control the memory use of SQL ?

    Thanks

    Satheesh

  • August 11, 2013 at 4:14 pm

    #1640433

    With the max server memory configuration setting.

    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

  • August 12, 2013 at 1:00 am

    #1640451

    Hello Gail ,

    Thank you for your reply .

    Can you please tell me where exactly this settings is ; in virtual memory settings or in SQL ?

    Thanks

    Satheesh

  • August 12, 2013 at 2:02 am

    #1640468

    SQL Server's configuration setting Max Server Memory.

    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

  • August 12, 2013 at 2:17 am

    #1640474

    Thank you.

  • August 13, 2013 at 9:11 am

    #1640987

    Alternately:

    EXEC sp_configure 'show advanced options',1;

    RECONFIGURE;

    EXEC sp_configure 'min server memory (MB)',8192;

    EXEC sp_configure 'max server memory (MB)',14336;

    RECONFIGURE;

    And investigate going into Group Policy (gpedit) and allowing your SQL Server service login account the Lock Pages in Memory right, if this is purely a SQL Server.

  • August 13, 2013 at 9:35 am

    #1641009

    Unless you have a really good reason otherwise, leave min server memory at default. 14.25GB is a little high on a 16 GB box. I'd usually start at 12 or 13 and increase if there's free memory.

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

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