Saturday, February 25, 2012

MSSQL Server 2000 Memory Grows Incrementally

Hi All
My SQL Server keeps on taking memory(RAM) on the server without
releasing it.
There seems to be a memory leak.
On every query that gets executed the memory occupied by MSSQL grows.
Does this make the subsequent queries execute slowly?
Also even though i execute the same query multiple time the memory size
still increases.
What could be the possible reason for this?
Thanks & Regards
Vishal.Vishal wrote:
> Hi All
> My SQL Server keeps on taking memory(RAM) on the server without
> releasing it.
> There seems to be a memory leak.
> On every query that gets executed the memory occupied by MSSQL grows.
> Does this make the subsequent queries execute slowly?
> Also even though i execute the same query multiple time the memory size
> still increases.
> What could be the possible reason for this?
> Thanks & Regards
> Vishal.
>
This is normal behavior. SQL Server will cache data pages in memory as
they are loaded from disk. It won't release memory unless it is
configured for dynamic memory allocation, AND the OS requests it.
Having SQL data cached in memory is a good thing, let it use as much as
it needs.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||The behaviour you are seeing is by design. Here is a KB article on the
subject:
INF: SQL Server Memory Usage
http://support.microsoft.com/defaul...b;en-us;q321363
Keith Kratochvil
"Vishal" <vishal.bhute@.gmail.com> wrote in message
news:1160134477.258235.198120@.h48g2000cwc.googlegroups.com...
> Hi All
> My SQL Server keeps on taking memory(RAM) on the server without
> releasing it.
> There seems to be a memory leak.
> On every query that gets executed the memory occupied by MSSQL grows.
> Does this make the subsequent queries execute slowly?
> Also even though i execute the same query multiple time the memory size
> still increases.
> What could be the possible reason for this?
> Thanks & Regards
> Vishal.
>|||Dear Tracy,
How to set up the "dynamic memory allocation" ?
Thanks
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:4526486E.4090509@.realsqlguy.com...
> Vishal wrote:
> This is normal behavior. SQL Server will cache data pages in memory as
> they are loaded from disk. It won't release memory unless it is
> configured for dynamic memory allocation, AND the OS requests it. Having
> SQL data cached in memory is a good thing, let it use as much as it needs.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Thanks Tracy
How to configure dynamic Memory Allocation'
Rgds
Vishal.
Tracy McKibben wrote:
> Vishal wrote:
> This is normal behavior. SQL Server will cache data pages in memory as
> they are loaded from disk. It won't release memory unless it is
> configured for dynamic memory allocation, AND the OS requests it.
> Having SQL data cached in memory is a good thing, let it use as much as
> it needs.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Vishal wrote:
> Thanks Tracy
> How to configure dynamic Memory Allocation'
See "Server Memory Options" under "Setting Configuration Options" in
Books Online...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Dear Tracy,
Thank you for your advice.
Peter
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:452B94DC.8000706@.realsqlguy.com...
> Vishal wrote:
> See "Server Memory Options" under "Setting Configuration Options" in Books
> Online...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com

No comments:

Post a Comment