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:

Abstract

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.

  1. Duplicate Indexes
  2. Index Fragmentation
  3. Big Indexes
  4. Backup Status – backup log
  5. Big One Time Use Queries – Queries Needing Parameters
The ideas for this class originated from the SQL Server Health Check reports.

Leave a Reply

Your email address will not be published. Required fields are marked *


2 − one =

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>