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

 

Looking for news about Giza? Oh it's coming, and it's now called NuvoSync

Register for info and our private beta!

 

Call Toll Free: 877.CLOUD.89         Call: 914.729.1029

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? Act now, the Premium edition of SQLScrubs is only $100. 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.

Once you're convinced that SCRUBS is for you, we offer a powerful Premium Edition of SCRUBS. Get it now.

 
     

Community Edition Report Catalog

 

Report Execution LogSCRUBS for Reporting Services - Report Execution Log

A detailed log of reports generated, ordered by execution start time

 

Report Execution DetailReporting Services Management Reports - Report Execution Detail

Displays the full detail of a specific report execution. Metrics included for performance, as well as the exact parameters used to generate the report.

 

Report Summary Generation StatisticsReporting Services Management Reports - Report Execution Detail

Provides average metrics related to the execution performance of a single report over a user specified date range.

Top ReportsReporting Services Management Reports - Report Execution Detail

Flexible report that displays the top reports by execution count.

 

Once you're convinced that SCRUBS is for you, we offer a powerful Premium Edition of SCRUBS. Get it now.

 

Premium Edition Report Catalog - only $100

 

Adds the following to the Community Edition Report Catalog

SSRS Performance 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.

 

Once you're convinced that SCRUBS is for you, we offer a powerful Premium Edition of SCRUBS. Get it now.

 

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