Ram Memory Uasage is full

  • arooj300

    Hall of Fame

    Points: 3433

    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

  • Gail Shaw

    SSC Guru

    Points: 1004424

    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: 258832

    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: 31255

    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

    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: 2744

    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)

Viewing 6 posts - 1 through 6 (of 6 total)

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