SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


sql server and ram


sql server and ram

Author
Message
ashrfa zaki mahgoob
ashrfa zaki mahgoob
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 24
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
Gianluca Sartori
Gianluca Sartori
SSCrazy Eights
SSCrazy Eights (9.8K reputation)SSCrazy Eights (9.8K reputation)SSCrazy Eights (9.8K reputation)SSCrazy Eights (9.8K reputation)SSCrazy Eights (9.8K reputation)SSCrazy Eights (9.8K reputation)SSCrazy Eights (9.8K reputation)SSCrazy Eights (9.8K reputation)

Group: General Forum Members
Points: 9818 Visits: 13350
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

How to post T-SQL questions
spaghettidba.com
@spaghettidba
ashrfa zaki mahgoob
ashrfa zaki mahgoob
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 24
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 ?
Tony Sweet
Tony Sweet
Valued Member
Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)

Group: General Forum Members
Points: 71 Visits: 66
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
Perry Whittle
Perry Whittle
SSCoach
SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)

Group: General Forum Members
Points: 19834 Visits: 17242
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" ;-)
Brandie Tarvin
Brandie Tarvin
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14488 Visits: 8989
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. @=)

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Perry Whittle
Perry Whittle
SSCoach
SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)

Group: General Forum Members
Points: 19834 Visits: 17242
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 :-D

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
Brandie Tarvin
Brandie Tarvin
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14488 Visits: 8989
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 :-D


That depends on what state you live in. I think it's against federal regulations to send those things through the mail. @=)

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search