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


Ram Memory Uasage is full


Ram Memory Uasage is full

Author
Message
arooj300
arooj300
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2237 Visits: 533
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
GilaMonster
GilaMonster
SSC Guru
SSC Guru (727K reputation)SSC Guru (727K reputation)SSC Guru (727K reputation)SSC Guru (727K reputation)SSC Guru (727K reputation)SSC Guru (727K reputation)SSC Guru (727K reputation)SSC Guru (727K reputation)

Group: General Forum Members
Points: 727327 Visits: 48475
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
Koen Verbeeck
SSC Guru
SSC Guru (191K reputation)SSC Guru (191K reputation)SSC Guru (191K reputation)SSC Guru (191K reputation)SSC Guru (191K reputation)SSC Guru (191K reputation)SSC Guru (191K reputation)SSC Guru (191K reputation)

Group: General Forum Members
Points: 191193 Visits: 13358
Why is there SSMS running on the production server?


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
Jo Pattyn
Jo Pattyn
SSC-Insane
SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)

Group: General Forum Members
Points: 22509 Visits: 10566
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
danielroach01
Valued Member
Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)

Group: General Forum Members
Points: 55 Visits: 6
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
Shafat Husain
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1936 Visits: 186
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)
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