SQL Server Health Reports — Working on Version 2
June 23, 2012 Leave a Comment
Late last year and early this year, I created a collection of report in SSRS that I called SQL Server Health reports.
Some of the things that the Server Health report evaluates are the following
- Index Fragmentation
- Big One Time Use Queries
- Long Running Queries
- Duplicate Indexes
- CPU Utilization
- Database Size
- Backup Set
But…. I have found it very challenging to distribute the SSRS reports in a way that they are easy to use for anyone anywhere with any SQL Server database environment.
So… The solution is to take the work done in the reports and port it into an application that can replace this collection of SSRS reports. I started on this project today, and think that over the next couple of months, I should be able to replace the existing SQL Server Health reports in SSRS with an application that hosts all the queries and makes it easier than it is now.
I am just getting started, but over the next couple of months I will be releasing the SQL Server Health reports as an application.