Making Progress on the Server Health Re-write

July 13, 2012 by Leave a Comment

Originally I implemented the  Database Health Reports as a series of SQL Server Reporting Services reports, which was very handy and easy to create, but hard to distribute in a way that they could be shared and customized to the needs of a project like the Database Health Reports should be.

Here is what I have so far, and I think that I am about a month and a half away from a Beta release, lets call it September 1st for the beta.  If you are interested in the beta, please register on this website, all registered users will be notified when the beta becomes available.

Here are a couple of sneak peak preview screenshots of the database health application.  This application includes reports on Backups, CPU by Query, Connections, Duplicate Indexes, Index Fragmentation, Long Running Queries, Plan Cache, Stored Procedure Performance, Statistics, Unused Indexes and much much more.

Here is a preview of the statistics report, and the Statistics Advisor.

So if you are interested in getting in on the Beta of the new Database Health Reports application, just register on this site and you will be notified when the beta becomes available, about the first of September.

Filed under Performance, Server Health Tagged with , , , , , , ,

SQL Server Health Reports — Working on Version 2

June 23, 2012 by 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

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.

Filed under Server Health, Uncategorized Tagged with , , , , , , ,

Abstracts submitted to SQL Saturday

November 26, 2011 by Leave a Comment

I just submitted abstracts to SQL Saturday  #114 in Vancouver and #108 in Redmond.

The Redmond SQL Saturday appears to be the more popular of the two.  Who knows if my session will get accepted, but I am giving it a shot.

 

Using SSRS reports to analyze SQL Server health

Assessing the health of your SQL Server with Several SQL Server Report Server reports designed for DBA’s and database developers to diagnose, and locate common pitfalls of SQL Server.  This includes reports for Duplicate Indexes, Index Fragmentation, Big Indexes, Backup Status – backup log, Big One Time Use Queries, Queries Needing Parameters and more.

 

Filed under Server Health, SQL Saturday Tagged with , , , , ,