SSRS slows down over time, requires restarting
Hi,
Our SSRS slows down over certain period of time (from a few days to a few weeks) - everything takes enormous amount of time, even loading the home page. After SSRS restart it works OK for a while and then we need another restart.
It becomes slow at the same time as the following errors start appearing in the SQL log:
Setting database option COMPATIBILITY_LEVEL to 100 for database ReportServer.
They disapper after the restart.
I was thinking about possible reports memory leakage over time, but how it correlates to these errors?
Any ideas?
Thanks
October 16th, 2012 10:17am
Hi,
1. What is your SSRS release and service pack?
2. How much RAM does your server have?
3. How much RAM you assigned to SSRS (via the config file)?
4. Are there any other applications running on the box? (i.e. a live SQL database other than ReportServer and ReportServerTempDB)
Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu
Free Windows Admin Tool Kit Click here and download it now
October 16th, 2012 10:50am
1. SQL Server 2008, SP1
2. 32 GB
3. 4 GB
4. There are other instances of SQL Server and SSRS
I realise that slowing down can be due to the memory pressure, but how it's connected to the COMPATIBILITY_LEVEL errors?
October 16th, 2012 11:29am
Hi,
#3. Please, sum the max memory allocated to all SQL instances (DB, SSAS and SSRS) on your box.
If it's greater than 28 Gb (32 Gb available - 4 Gb you typically reserve for OS stuff) then you're in trouble.
IMHO, the "COMPATIBILITY_LEVEL" messages are bogus, fact is SSRS instance is stressed because of low memory.
Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu
Free Windows Admin Tool Kit Click here and download it now
October 16th, 2012 1:40pm