Home Forums SQL Server 2005 Administering SQL Connection memory usage is growing steadily RE: SQL Connection memory usage is growing steadily

  • January 28, 2013 at 11:16 am

    #1581743

    Lowell (1/28/2013)

    that is by design, and the normal behaviour for SQL server:

    SQL tries to keep everything in memory to support subsequent queries. if you leave an installation at it's default settings(2 Terabytes?,which is more memory than anyone realistically will ever own), it will use ALL of the memory, and possibly starve the operating system for memory as well.

    The whole idea is to keep everything in memory, instead of going to disk, as that IO operation slows things down.

    it is not like other programs, that give memory back when it is "done"...it's never done, as far as SQL is concerned.

    you can limit the amount of memory int eh memory settings under the server properties in the SSMS Object Explorer:

    Thanks Lowell.

    As mentioned in the post, we set the max memory. Buffer Cache and Procedure Cache both are fine. But the connection memory keeps increasing and eventually eat all 56G memory and none process can be going on.