Post reply

RAM Use of SQL server

  • November 8, 2017 at 10:25 pm

    #402660

    Hi all!

    I have a developement SQL server, that consumnes  so much RAM, that my PC chokes on it. from 3200 MB to app 4200 MB.
    I found a script in a seach on this page, that shows the RAM use of the individual DB's on the pc - iits about 1200 MB in total.

    Is there a setting, or what to do?

    Best regards

    Edvard Korsbæk

  • November 9, 2017 at 1:09 am

    #1967307

    SQL will use as much RAM as you tell it to.  By default this is 2PB of RAM.  You need to go into the memory settings and set a max memory to cap the amount of RAM SQL can use.

    You cannot limit the amount of RAM per database, only at the instance level.

  • November 9, 2017 at 1:45 am

    #1967311

    anthony.green - Thursday, November 9, 2017 1:09 AM

      You need to go into the memory settings and set a max memory to cap the amount of RAM SQL can use.

    Thanks, and I found them under server properties.

    max is 2147483647, and I intend to set it to 3000 instead...

    Best regards

    Edvard Korsbæk

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

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