Take Command of Your SQL Server Reporting Services Instance with sp_BlitzRS®.
Your SQL Server Reporting Services instances can be hard to manage. Built-in tools like Report Manager will give you some general information, but not enough to feel like you are in complete control. BlitzRS is designed to take the guesswork out of running Reporting Services. It will help answer questions like:
- If a staff member quits, what subscriptions they were getting (so I can send them to their replacement)?
- Is my server under pressure because queries are slow, or because the reports are too big?
- Are there reports that would good candidates for caching or snapshots?
- Do I have reports that are using dangerous settings or patterns?
Our free sp_BlitzRS® stored procedure quickly evaluates your SSRS server’s operations and reports back to you. Each finding has a URL that explains what to look for and how to handle the issue. You can probe deeper for more information on events like upcoming reports and overlapping schedules. The query outputs are great not only for reading, but also as a source for further analysis in Excel. sp_BlitzRS® is compatible with SQL Server Reporting Services on versions 2008 and later (2008 R2, 2012, 2014).[youtube]meTPWKTLJ90[/youtube]
Get sp_BlitzRS® now!
Current version: v0.90 – Beta (Aug 28, 2014)