Skip Navigation LinksHome : SCRUBS : Report Catalog
Skip Navigation Links.

   

        

Management & Optimization for SQL SSRS

 

The Challenge

Reports for your SQL Reporting Services reports? Yes. Reporting Services Management Reports - Report Execution Detail

Want to know the longest running reports? Top users? Which reports should be targeted for optimization and tuning? How about IT Governance; to determine who's reviewing certain types of data, or who isn't using your platform at all?

Want to make sense of the SQL Server Reporting Services Execution Log?  Get it now.

Do you have multiple reporting instances or provide a multi-tenant platform for SSRS? Do you need to know how much bandwidth reports, sites or users are consuming?

The Solution

SCRUBS - SummitCloud Reporting Utility Belt for SQL Server provides a complete infrastructure to review report execution, metrics and analysis of your reporting environment.

 
     

Premium Edition Report Catalog

 

SSRS Performance Reports

Scrubs Dashboard Only in Scrubs 2012Reporting Services Management Reports - Report Execution Detail

A launchpad for audit of the past week and month (adjustable) of reporting usage. Used as a lauch pad to drive to the Execution Detail and other reports.

Report Execution Log – Enhanced VersionReporting Services Management Reports - Report Execution Detail

A detailed log of reports generated ordered by execution time. Enhanced version allows for filtering by source type.

Report Summary Generation Statistics – Enhanced VersionReporting Services Management Reports - Report Execution Detail

Provides average metrics related to the execution performance of a single report over a user specified date range. Enhanced version adds traffic path analysis, to analyze types of execution (render, drillthru, etc.)

Dynamic Top ReportsReporting Services Management Reports - Report Execution Detail

Adds flexible dynamic filters to the standard Top Reports analytic. View by Average, Min, or Max for the following metrics: Processing Time, File Size, Row Count, Peak Memory, and more.

Slowest ReportsReporting Services Management Reports - Report Execution Detail

Analysis of the slowest reports (on average) for a specified date range.

User ProfileReporting Services Management Reports - Report Execution Detail

Dashboard of metrics by report user. Includes top reports, execution times, time of day and more.

Largest ReportsReporting Services Management Reports - Report Execution Detail

Analysis of the largest reports (on average) for a specified date range.

Site / Folder StatisticsReporting Services Management Reports - Report Execution Detail

Displays usage statistics by Site/Folder with breakdown by hour of day, day of week and % of data usage

User StatisticsReporting Services Management Reports - Report Execution Detail

Displays usage statistics by report users with breakdown by hour of day, day of week and % of data usage. Quick link to User Profile report.

Optimization AnalysisReporting Services Management Reports - Report Execution Detail

An exception reporting dashboard that displays reports that might be good candidates for optimization based upon resource utilization and failures.

SSRS Instance StatisticsReporting Services Management Reports - Report Execution Detail

Displays usage statistics by SSRS Instance with breakdown by hour of day, day of week and % of data usage.

SSRS IT Governance Reports

SSRS Report CatalogReporting Services Management Reports - Report Execution Detail

Full report catalog with usage statistics and links to drill-thru detail.

SSRS User CatalogReporting Services Management Reports - Report Execution Detail

Listing of report users and usage statistics with linkage to User Profile. Emphasis provided for users no longer using the SSRS catalog.

Parameter String InquiryReporting Services Management Reports - Report Execution Detail

Answers the question “Who’s running reports for the ‘Higgins Account?’ This report provides a text based search for character string in a Parameter.

Report Parameter InquiryReporting Services Management Reports - Report Execution Detail

Retrieve user and report execution data based upon selected report parameters. Determine who is running reports with specific parameter values.

Report Execution Detail with Path AnalysisReporting Services Management Reports - Report Execution Detail

Displays the full detail of a specific report execution. Includes the action path the user took while navigating within the report (Sort, Drill-through, click Document Map, etc.) and the execution metrics for each action.

 

 Get it now.

 

Copyright 2015. All rights reserved. All brand, product, service and process names appearing on this website are trademarks of their respective holders.