Ram Memory Uasage is full

  • 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

  • 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
  • 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

  • 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

  • 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.

  • 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)

  • This was removed by the editor as SPAM

  • 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.

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

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