Post reply

How to restrict memory in SQL Server 2008 R2 64 Bit Standard Edition

  • February 6, 2014 at 4:58 am

    #303784

    Hi,

    In one of my production database server total physical memory is 32GB and i restrict upto 28GB (Under server property) but every time SQL Server utilized morethan 30GB. What's going on the server kindly help on this.

    Note: Not enabled AWE option.

    Pradeep.

    Pradeep

  • February 6, 2014 at 5:05 am

    #1686530

    Max server memory limits the buffer pool. SQL can use a small amount of memory in addition to that. If it's using too much, reduce 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

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

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