September 20, 2012 at 6:05 am
I'm a data analyst in an ops reporting group. I say that so you'll know I don't pretend to be an expert on servers. We have a reporting server with multiple reports with subscriptions. The server has been operational for at least two years (2008 incarnation) with no problems. In the last month or so, we have had complaints from our recipients about late reports. There are around 32 daily reports affected. We've been monitoring the server for the last 10 days and see that the reports are running at the time scheduled, but they are hanging out in a pending state. Suddenly, as if a dam bursts, three-four hours after they've run, they will all be emailed at once. We've asked IT for help, but they are severely short-handed and have told us that it's hardware-related and there's no budget until next year to upgrade. I think this is their standard reaction unless we can give them more evidence otherwise. We don't get much respect ;>) I suspect there's something else amiss because nothing has changed on our server in the last two months to account for the degradation in service. I suspected an issue with our exchange server but another team member who's more knowledgeable about that sort of thing, says that the reports aren't even being presented to the exchange server. The team would like to present IT with some evidence that there's something more than a hardware issue going on. It's hard to get them to allocate any time for troubleshooting our ops server unless we can point them in the right direction.
There are two of us have admin rights to the server. Is there anything we can check to see what is causing the bottleneck so we can take it back to our IT team? Thanks so much for any help you can give us.
September 20, 2012 at 6:15 am
Check the executionlog view in the reportserver database and check the processing and rendering time, if these are huge and tie in with the delay in the subscription starting and the email receiving then you will need to tune the SQL or strip out some of the report to make it more compact.
If the report execution and rendering take a matter of seconds, then I would say there is a delay in the email server sending out mail so that would be one to ask IT for help on.
Do you have any maintenance routines which run to for example rebuild indexes or statistics at all?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply