In Spotlight 11.7, the reports repository gets a major boost!
The list of current robust reports is being enhanced by the introduction of 23 new reports. These new reports were the result of converting application display views which were very limited in their capability. In comparison to display views, Spotlight reports are designed in SQL Server Report Definition Language (RDL) format. As a result, in addition to providing the capability of accessing them in Spotlight, these files can be opened, customized, and published using SSRS. Additionally, some reports facilitate reporting across multiple connections for a more comprehensive analytical review of data.
The following is the list of the new reports:
All SQL Agent Jobs ReportCustom Counters ReportDatabase Setting ReportFailed SQL Agent Jobs ReportSQL Server Blocking ReportSQL Analysis Workload ReportSQL Server General Statistics ReportSQL Server Health Database Files ReportSQL Server Health Table Summary ReportSQL Server Index Summary ReportSQL Server Job Duration ReportSQL Server Keyed Metric ReportSQL Server Large Databases ReportSQL Server Metric ReportSQL Server Redundant and Revers Indexes ReportSQL Server Tables Missing Clustered Indexes or Primary Keys ReportSQL Server Transaction Single Day Summary ReportSQL Server Wait Statistics ReportWindows Configuration ReportWindows General Statistics ReportWindows Hardware Configuration ReportWindows Keyed Metric ReportWindows Metric Report
In the Example below in SQL Server Large Databases Report, multiple connections have been selected from the Connection Name pick list:
Report results show outcome of selected connections:
For details on these reports, refer to Spotlight Reporting and Trending Guide.
Download the latest version of Spotlight from here or reach us on Twitter.