Post reply

sql server max memory

  • June 12, 2012 at 4:48 pm

    #259242

    Sql server max memory config is 100GB and total memory is 128 GB.

    64 bit sql server 2008 SP3 enterprise.

    Though the max server memory is 100 GB , sql server is just making use of 60GB from past few weeks.

    Need help to figure out this issue.

    Thanks,

  • June 12, 2012 at 4:59 pm

    #1500100

    Not a problem. SQL Server is able to meet your users needs with only 60 GB of memory. If it needs more, it will take it and use it up to the 100 GB you have set as the maximum memory for SQL Server.

  • June 15, 2012 at 8:13 am

    #1501694

    Agree 100% with Lynn. Is there any signs of memory pressure or any other reason why you think it should be using more than it is? If not, then you're fine.

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

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

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