Why the memory usage of SqlServer doesn't go down

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Jenniflower
    #1

    Why the memory usage of SqlServer doesn't go down

    Hi Gurus,

    Our system is using SqlServer 2005 on XP.( On my machine,only this
    application access SQLServer.) The sqlserver memory is configured to
    128MB (Min)~512 MB(Max)

    After our system get started, sqlserver takes about 100M memory. After
    the system runs for a while, the memory used by sqlserver goes up to
    512MB. Then we exit our application and expect the memory usage of
    SqlServer could be dropped down to the min value. Unfortunately, it
    seems SqlServer never release any memory until we restart it.

    I thought dynamic memory configuration means that SQLServer can auto
    shrink memory usage if there is no more database accessing. But based
    on my observation, SQLserver just holds all the memory . :( How can
    we let the sqlServer shrink the memory usage accordingly to workload?


    I do appreciate for your help!

    Best regards,



    Jennifer

    Tags: None
    • Stu
      #2
      Re: Why the memory usage of SqlServer doesn't go down

      Not trying to be harsh, but you thought wrong :) SQL Server won't
      release the memory back to the min configuration until Windows needs
      it; are you having memory issues?

      Stu


      Jenniflower wrote:
      Hi Gurus,
      >
      Our system is using SqlServer 2005 on XP.( On my machine,only this
      application access SQLServer.) The sqlserver memory is configured to
      128MB (Min)~512 MB(Max)
      >
      After our system get started, sqlserver takes about 100M memory. After
      the system runs for a while, the memory used by sqlserver goes up to
      512MB. Then we exit our application and expect the memory usage of
      SqlServer could be dropped down to the min value. Unfortunately, it
      seems SqlServer never release any memory until we restart it.
      >
      I thought dynamic memory configuration means that SQLServer can auto
      shrink memory usage if there is no more database accessing. But based
      on my observation, SQLserver just holds all the memory . :( How can
      we let the sqlServer shrink the memory usage accordingly to workload?
      >
      >
      I do appreciate for your help!
      >
      Best regards,
      >
      >
      >
      Jennifer

        Comment

        • Jenniflower
          #3
          Re: Why the memory usage of SqlServer doesn't go down

          Hi Stu,

          I got you point. Because after we exit our system, there is no memory
          issues , SQLServer can just hold 512M memory. To be simple, SQLServer
          always tries
          to keep all acquired memory until OS runs out of memory and asks it to
          relinguish
          some to other applications.

          Thanks !

          Jennifer,

          Stu wrote:
          Not trying to be harsh, but you thought wrong :) SQL Server won't
          release the memory back to the min configuration until Windows needs
          it; are you having memory issues?
          >
          Stu
          >
          >
          Jenniflower wrote:
          Hi Gurus,

          Our system is using SqlServer 2005 on XP.( On my machine,only this
          application access SQLServer.) The sqlserver memory is configured to
          128MB (Min)~512 MB(Max)

          After our system get started, sqlserver takes about 100M memory. After
          the system runs for a while, the memory used by sqlserver goes up to
          512MB. Then we exit our application and expect the memory usage of
          SqlServer could be dropped down to the min value. Unfortunately, it
          seems SqlServer never release any memory until we restart it.

          I thought dynamic memory configuration means that SQLServer can auto
          shrink memory usage if there is no more database accessing. But based
          on my observation, SQLserver just holds all the memory . :( How can
          we let the sqlServer shrink the memory usage accordingly to workload?


          I do appreciate for your help!

          Best regards,



          Jennifer

            Comment

            Previous template Next
            Working...