Posts Tagged ‘SCRUBS’
Monitor and Analyze Multiple SSRS Instances with SQLScrubs
The following article details how to analyze and monitor multiple SQL Reporting Services instances with SQLScrubs. SQLScrubs Community Edition is available for free and can be found on CodePlex. All extraction for instance related data is managed by the SSIS package and stored in the datawarehouse provided. You can analyze in your own reports, enhance some of the free reports to do this for you, or simply upgrade to the Premium Edition of SCRUBS for SQL Server 2008 which provides over 15 additional reports with built-in analysis by instance.
Analyze and Optimize SQL Server Reporting Services Reports
Things to look for in SSRS optimization include the following:
Long running reports
Which reports have the longest total duration?
If the TimeDataRetrieval is high, the data source could be a bottleneck, or [...]
