Posted by Stu on 10/02/99 11:54

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

[Back to original message]