|
* Customer Testimonial
 Answer these questions with SQL Scrubs:
- Which reports are slowest, largest or most heavily utilized?
- Who are my power users?
- Who isn't running reports?
- Who is running reports against privileged data?
- Which reports need to be tuned?
- How much bandwidth are my report users/tenants using?
What's New for SQL Scrubs 2012?
- Optimized for SQL Server 2012
- pull logging data from SSRS instances on SQL Server 2012, SQL Server 2008 , SQL Server 2008 R2 *
- Dataset usage logging and detail report (when available from the SSRS log) **
- ALL NEW Dashboard report! All new launch pad for SQL Scrubs reports
- A script to update an existing SQL SCRUBS 2008 database for use with SCRUBS 2012 extract package and SCRUBS 2012 reports *
- Updated report names for usability (drill through and subreports noted to reduce reporting confusion)
* The SQL Scrubs database, SSIS package and Scrubs SSRS reports MUST still reside and execute from a SQL Server 2012 instance (either Standard or Enterprise).
** Dataset reporting is only available when provided by the SSRS Execution Logs. Please note that SSRS does not capture detailed audit information on dataset usage for all reports. Where avaialable, Scrubs will cull that data and make it available in the SCRUBS data warehouse.
New Dashboard in SCRUBS 2012
The Must Have SSRS Audit Tool!
Includes over 15 report objects for managing, optimizing,
auditing and
identifying the key areas of your SQL Server Reporting Services (SSRS)
architecture.
Get it
now!
SQL SCRUBS is available in versions for SQL Server 2012, SQL Server 2008 & 2008 R2
Used by Frito Lay, Ameriprise, Belgacom, Trek Bikes and over 1000 other companies
Reports Included
 |
EXECUTION LOG
Detailed log of report execution with flexible filters.
|
|
|
SUMMARY STATS
Rich report analytics related to execution performance.
|
|
 |
TOP REPORTS
Dynamic filter of reports by File Size, Processing Time, Row Count, Peak
Memory, and more .
|
|
|
SLOWEST REPORTS
Analysis of the slowest reports (on average) for a specified date range.
|
|
|
|
USER PROFILE
Dashboard of metrics by report user. Includes top reports, execution times, time
of day and more.
|
|
|
|
LARGEST REPORTS
Analysis of the largest reports (on average) for a specified date range.
|
|
|
SITE/FOLDER STATS
usage statistics by Site/Folder with breakdown by hour of day, day of week and % of data usage.
|
|
|
|
USER STATS
Usage statistics by report users with breakdown by hour of day, day of week and % of data usage.
|
|
|
INSTANCE STATS
Usage statistics by SSRS Instance with breakdown by hour of day, day of week and % of data usage.
|
|
|
|
OPTIMIZATION ANALYSIS
displays reports that might be good candidates for optimization based upon resource utilization and failures.
|
|
|
USER AUDIT
Listing of report users and usage statistics. Emphasis provided for users no longer using the SSRS catalog.
|
|
|
|
REPORT AUDIT
Complete report catalog for auditing usage stats and links to drill-thru detail.
|
|
|
PARAMETER AUDIT
Retrieve user and report execution data based upon selected report parameters.
Find out who is running reports with specific parameter values.
|
|
|
|
STRING AUDIT
This report answers the question “Who’s running reports for ‘Contoso Inc?’
by inspecting parameters for text you specify.
|
|
|
PATH ANALYSIS
F ull detail of report execution and includes the action path
taken while navigating within the report (Sort, Drill-through, click Document Map, etc.)
|
|
|
|
SOURCE INCLUDED!
Visual Studio solution with all SSRS reports, and SSIS package included so you
can extend or customize.
|
|
|
Everything you need, get started in minutes!
SQLScrubs includes the datawarehouse to store the SSRS logs, SSIS integration
package and a Visual Studio solution of all reports. Connect to native SSRS or
SharePoint integrated installations (or both!) and start reporting in minutes.
Purchase SQLScrubs Premium Edition now!
Complete source code means you can tailor and extend the base package and
reports to suit your needs.
See the features list here, or get it now!
Get it now!
Purchase and secure download instantly.
Get SQLScrubs Premium Edition now! |