April 17, 2014 at 7:59 am
i have a production server with 25 Gb ram ,64 bit windows and sql
i run ERP module all ram used by sql server and after close the application
RAM IS NOT REALESED IT STILL IN MAX USAGE
WHAT THE PROBLEAM
SORRY FOR MY BAD ENGLISH
April 17, 2014 at 8:13 am
SQL Server never releases the memory it uses, unless told so by the operating system.
Your ERP module is not your SQL Server. When you close the application, SQL Server still runs in the background.
If this is not a server and you want to release memory back to the operating system, just cycle the SQL Server service. Since you say this is your production server, you don't really want to do that.
If you want to prevent SQL Server from using all your available RAM, set the Maximum Server Memory option in the instace properties. If this server is dedicated to SQL Server, you could set it at around 20 GB.
-- Gianluca Sartori
April 17, 2014 at 8:43 am
thnxs spaghettidba
what i understand is after closeing the ERP A application IT IS USUAL TO RAM TO GET DOWN NOT STILL MAX USAGE THAT WHAT HAPPEN IN ANY APPLICATION I RUN IN SQL SERVER IS THAT WRONG ?
April 17, 2014 at 8:50 am
SQL Server gradually grabs RAM as it needs it to run queries, etc. It does not release RAM until you cycle the service or the OS tells it to give up the RAM. This does not mean SQL Server is always utilizing all of the RAM it has, it just means other applications are not able to grab the RAM.
If SQL is the only thing installed on the server, you should set MAX RAM to around 2GB less than the total RAM on the server. This way the OS can function.
Here is an article about how to set MAX RAM: http://technet.microsoft.com/en-us/library/ms191144(v=sql.105).aspx
Hope that helps.
- Tony Sweet
April 18, 2014 at 4:21 am
Tony Sweet (4/17/2014)
It does not release RAM until you cycle the service or the OS tells it to give up the RAM.
or if you lower the max memory setting
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2014 at 6:22 am
Perry Whittle (4/18/2014)
Tony Sweet (4/17/2014)
It does not release RAM until you cycle the service or the OS tells it to give up the RAM.or if you lower the max memory setting
But none of us recommend you lower the max memory setting unless you know the consequences. That way leads madness, badness, and just plain crazy support issues. @=)
April 18, 2014 at 7:17 am
Brandie Tarvin (4/18/2014)
But none of us recommend you lower the max memory setting unless you know the consequences.
You would do if your server starts blue screening because its under memory starvation 😉
Brandie Tarvin (4/18/2014)
That way leads madness, badness, and just plain crazy support issues. @=)
I don't know what you're smoking but i'll have some of it 😀
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2014 at 7:23 am
Perry Whittle (4/18/2014)
Brandie Tarvin (4/18/2014)
But none of us recommend you lower the max memory setting unless you know the consequences.You would do if your server starts blue screening because its under memory starvation 😉
Did I miss indications that he's running into a problem? It seems to me the OP just asked the same question that comes up once a week about SQL Server memory.
Also, if the OP doesn't understand how SQL Server works with RAM, how can he understand the consequences (good and bad) of messing with the settings?
Brandie Tarvin (4/18/2014)
That way leads madness, badness, and just plain crazy support issues. @=)I don't know what you're smoking but i'll have some of it 😀
That depends on what state you live in. I think it's against federal regulations to send those things through the mail. @=)
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply