Post reply

SQL 2008 R2 High Memory Usage

  • June 10, 2013 at 3:08 am

    #394937

    Dears, is it normal when sqlservr.exe takes that much of memory usage ?

    The installed is Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) over Windows 2008 R2 SP1

    Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

    Please check the attached screen shot and let me know if further information is needed.

    Thanks all and really I appreciate your fast response as this is a production DB.

  • June 10, 2013 at 3:11 am

    #1622346

    Perfectly normal. Unless you set max server memory otherwise, SQL can and will use as much memory as is available on the server.

    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 10, 2013 at 3:12 am

    #1622348

    Thank you very much 🙂

  • June 10, 2013 at 3:15 am

    #1622350

    As I used the default settings , I didn't adjust any parameter related to the memory.

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

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