Ram Memory Uasage is full

Question

Post reply

Ram Memory Uasage is full

arooj300

Hall of Fame

Points: 3433
More actions
April 9, 2014 at 6:35 am

#292078

Hi All,
I am using SQL SERVER 2008R2 in Window 7 with 16 GB RAM, and three production database are running on that server.
I am worrying about Memory usage reserverd upto 15.1 GB out of 16 GB. and most of the memory has taken by SSMs & SSRS. but when at night there is no user is working at that time Memory usage will not be release the space , it will be remain same. because of that we have got complain that application is running slow from the users and sometimes while generating the reports its throw the error" out of memory".
can anyone please help me on this.
Thanks,
Arooj
March 11, 2017 at 11:53 am

This was removed by the editor as SPAM
December 21, 2022 at 7:27 am

This was removed by the editor as SPAM

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

What you're seeing there is perfectly normal, expected, documented behaviour.

Chapter 4: http://www.red-gate.com/community/books/accidental-dba

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 2

Why is there SSMS running on the production server?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Jo Pattyn SSC-Dedicated Points: 32350 More actions · Answer 3

You can specify an upper limit for the sql server instance buffer pool (not all memory, but a great deal)

Apperantly reportingservices has also a kind of memory policy

Leave 4 GB as a buffer for OS and other applications (like virusscanners, backupagents...)

Management Studio/Profiler shoudn't be open on the server itself

danielroach01 Valued Member Points: 67 More actions · Answer 4

These SSMS which is running on the production server need more memory space upto 32GB in Window 7. I think you should update your window and Ram too. I installed 1TB Ram in my PC because in future SSMS not creating any problem with the server and also take its backup.

Shafat Husain SSCrazy Points: 2754 More actions · Answer 5

Dear Arooj,

Do you have any scheduled reports running on the server? Scheduled reports takes up a lot of memory, setting up the WorkingSetMaximum,WorkingSetMinimum value in RsReportServer.config file will help setting a CAP on the memory utilization by SSRS.

You can start with that and check the performance.

You can check the listed article for help on setting up these parameters.

# http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/07/09/configuring-available-memory-for-sql-server-reporting-services.aspx

Hope it Helps..!!

Regards,
Shafat Husain
🙂
And Your Lord Never Forgets...!! (64:19 -- Quran)

ethanbrody02 Valued Member Points: 63 More actions · Answer 6

SQL Server will use all of the memory that you let it use. Check the maximum memory setting and, if necessary, lower it to make sure the operating system on your device can work properly. A good rule of thumb is to use no more than 4 gigabytes, or 10% of the total RAM. This is just a starting point; you may need to make more changes depending on how much work SQL Server and anything else VM is doing is putting on it.