Using SSRS reports to analyze SQL Server health
This is a draft copy that it still being worked on.
The Using SSRS reports to analyze SQL Server health planned for January 2012 will include the following:
Assessing the health of your SQL Server with 5 SQL Server Report Server reports designed for DBA’s and database developers to diagnose, and locate 5 common pitfalls of SQL Server.
- Duplicate Indexes
- Index Fragmentation
- Big Indexes
- Backup Status – backup log
- Big One Time Use Queries – Queries Needing Parameters
The ideas for this class originated from the SQL Server Health Check reports.