|
|
Posted by Jenniflower on 10/02/47 11:54
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
Navigation:
[Reply to this message]
|