Memory Mgt in SQL SERVER

[smileydip]

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.

[johnbandettini]

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

[Andy Williams]

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.

[Greg D. Moore \(Strider\)]

"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.