469,903 Members | 1,579 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,903 developers. It's quick & easy.

Memory Mgt in SQL SERVER

I have a performance and memory management issues with SQL SERVER. I
feel SQL server does not releases the unused memory back to the OS. I
have been monitoring that at the end of the day the SQL SERVER
performance gets really bad. And it this point it has acquired all the
Cache it could. I have abt 4 GB of RAM on my server and out of it SQL
SERVER uses almost 2.7 GB whether there is load on the machine or not.
If there any way or tool to monitor this. Also is there any way to Free
memory from SQL server back to OS.

Jul 23 '05 #1
3 1449
Hi

If you have SQL Server configured to use memory dynamically, (Which is
the default and usually best left unless you have a speciffic reason to
change it) SQL Server will take as much memory as it needs. It then
does not release that memory unless another process needs it. It is
designed to work that way. I believe the only way to reset the memory
usage is to stop and start the SQL Server service. If it is not causing
a problem don't worry about it.

If it does cause a problem, set a limit on the amount of memory that
SQL Server can use.

Regards

John

Jul 23 '05 #2
Take a look at:

http://support.microsoft.com/default...b;en-us;321363

-Andy

"smileydip" <di**********@gmail.com> wrote in message
news:11********************@f14g2000cwb.googlegrou ps.com...
I have a performance and memory management issues with SQL SERVER. I
feel SQL server does not releases the unused memory back to the OS. I
have been monitoring that at the end of the day the SQL SERVER
performance gets really bad. And it this point it has acquired all the
Cache it could. I have abt 4 GB of RAM on my server and out of it SQL
SERVER uses almost 2.7 GB whether there is load on the machine or not.
If there any way or tool to monitor this. Also is there any way to Free
memory from SQL server back to OS.

Jul 23 '05 #3

"smileydip" <di**********@gmail.com> wrote in message
news:11********************@f14g2000cwb.googlegrou ps.com...
I have a performance and memory management issues with SQL SERVER. I
feel SQL server does not releases the unused memory back to the OS.
Unless you're using AWE, it does release memory to the OS if the OS request.

However, as SQL is faster with as much memory as possible, it normally will
grab as much as it can and keep it as long as itcan.
I
have been monitoring that at the end of the day the SQL SERVER
performance gets really bad. And it this point it has acquired all the
Cache it could. I have abt 4 GB of RAM on my server and out of it SQL
SERVER uses almost 2.7 GB whether there is load on the machine or not.
Sounds about right.
If there any way or tool to monitor this. Also is there any way to Free
memory from SQL server back to OS.
Why do you think this will help your performance issue? Almost certainly
the performance issue is related to something else.


Jul 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Frank Esser | last post: by
2 posts views Thread by Evert Wiesenekker | last post: by
12 posts views Thread by Bardolator | last post: by
16 posts views Thread by Justin Lazanowski | last post: by
1 post views Thread by Antar | last post: by
9 posts views Thread by Raziq Shekha | last post: by
1 post views Thread by Raziq Shekha | last post: by
3 posts views Thread by Florin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.