Why the memory usage of SqlServer doesn't go down

[Jenniflower]

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

[Stu]

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

[Jenniflower]

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