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 Statistics But…. I have found it very challenging to …
SQL Server Health Reports — Working on Version 2 Read more »
After yesterdays Long Running Queries Report, I have decided to add one more SQL Server Health report. A duplicate indexes report has been added to the Server Health reports. With this report you can track down time waste associated with duplicate indexes. Here is a sample of the new free report. This is part of my growing collection of free SSRS reports to …
A long running queries report has been added to the Server Health reports. With this report you can track down time consuming queries that may be causing excessive load on your server. Here is a sample of the new free report. Download and Enjoy.