No announcement yet.

SQL Server Memory Usage

  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL Server Memory Usage


    On our Server 2008, we have two sqlservr.exe processes running on our Server 2008.

    I don't know enough to know if this is correct, but we have 8GB RAM memory in total and 5.8Gb is now showing as being used in the Physical Memory Usage History.

    Is this correct?

    I ask because users are complaining of slow opening of files from the server.

    Thanks, Chris.
    Attached Files

  • #2
    Re: SQL Server Memory Usage

    Better quality screenshot attached.
    Attached Files


    • #3
      Re: SQL Server Memory Usage

      SQL server is one of several applications that grab all available memory, but release it gracefully as other applications or processes need it.

      You can limit the memory an instance uses by going into SQL Server Management Studio, connecting to the database engine for the instance you want to change, right clicking on the server, then properties and going to the MEMORY tab and changing the max memory. Remember you may have multiple instances of SQL server running on one machine

      IIRC a reboot is not required

      Of course, the question is "is SQL performance more important than file access?"
      Tom Jones
      MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
      PhD, MSc, FIAP, MIITT
      IT Trainer / Consultant
      Ossian Ltd

      ** Remember to give credit where credit is due and leave reputation points where appropriate **