RAM Use of SQL server

• Edvard Korsbæk

  SSCertifiable

  Points: 5999

  More actions

  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

• Ant-Green

  SSC Guru

  Points: 113544

  More actions

  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.

• Edvard Korsbæk

  SSCertifiable

  Points: 5999

  More actions

  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