Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning SQL Server 2008 R2 Memory Hog RE: SQL Server 2008 R2 Memory Hog

  • March 10, 2014 at 5:12 am

    #1695478

    Min server memory is fine at 0. What's the exact value for max server memory?

    Run

    exec sp_configure 'show advanced', 1

    RECONFIGURE

    exec sp_configure 'max server memory'

    What's the exact output?

    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