SSRS Memory Performance
Home > IT Answers > SQL Server > SSRS Memory Performance
MJT
20 pts.
0
Q:
SSRS Memory Performance
SQL Server 2005, Reporting Services 2005, SSRS 2005, SSRS reports, Microsoft SQL Reporting Services, SSRS Performance, SSRS Errors
Microsoft SQL Server Reporting Services Version 9.00.3239.00

We are experiencing problems with memory and other performance related issues. This is a scaled out deployment with ssrs installed on 2 server web farm (used to be 3) with windows 2003 sp2, 32GB RAM. Customers run 100s of subscriptions (some quite long running) and we are running into issues with memory and the server hangs up or services crash and restart
ASKED: Nov 20 2008  9:03 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
MJT
20 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Last Answered: Nov 20 2008  9:03 PM GMT by MJT   20 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Mrdenny   46795 pts.  |   Nov 21 2008  6:53PM GMT

Did you have a specific question about SSRS or about the config? It could be as simple as there are to many very large reports which take a lot of RAM each being run at the same time.

 

MJT   20 pts.  |   Dec 1 2008  5:38PM GMT

Projects do run 1000s of scheduled reports and they do run many times at or about the same times do to contracted delivery times with clients. We just turned on verbose logging to attempt to get more information. I noticed now that the report server service_main log file is HUGE and reporting percentage of memory consumed every second - I dont think we want THAT much information! Info isnt enough but I will have to turn off Verbose if there isnt a way to make this one log file not report one line per second for the memory.

 

Mrdenny   46795 pts.  |   Dec 2 2008  8:05PM GMT

When you tell Reporting Services that you want Verbose logging it means it.

If your reporting services machines are running out of memory and it’s logging memory usage, all the info that you need to fix the problem is in the log, you just need to find it.

 
0