REAL TIME SQL SERVER ANALYSIS REPORTING  

RockSolid incorporates a full reporting library to assist management and DBAs. The reports collate and analyze data to help plan, optimize and effectively manage the SQL Server environment. All reports can be run interactively, allowing parameters such as the date range or number of days reported on to be altered, and most can be generated as a PDF document.

Reports can also be scheduled to run at specific times, and emailed to nominated recipients. There are three categories of reports; operational, capacity and performance – some examples are listed below.





OPERATIONAL REPORTS

• Environment Health Audit Report
• Backup Status Report
• SQL Server Availability Report
• Instance and Database Detail Reports
• Log Shipping Status Report
• Instance Change History Report

CAPACITY REPORTS

• Disk Space Capacity Planning Reporting
• Database Space Prediction Report
• Current Disk Space Utilization Report
• Table Growth Report
• Database Space Usage Report
• Database Placement Recommendation Report

PERFORMANCE REPORTS

• SQL Server Performance Management Report
• Query impact report
• Blocking Query Report
• I/O Wait Time Report
• Performance Issue Analysis Report
• Application Impact Report
• Backup Performance Report
• CPU Pressure Report