In October last year I started work on the Database Health reports project. It started out as a series of SSRS reports that I released and updated in December 2011 to March 2012. After that it became clear that the SSRS reports weren’t going to do what I was looking for so I started on the Database Health reports version …
It is finally here. Beta 1 of the Database Health Reports for SQL Server. Read more »
As I get the Database Health project ready to release as a beta, more of the components are coming together. For instance shown here is the Table Size Advisor which can be accessed from the Disk Space Report. In this example you can quickly see that the Demographics column in the Person table is taking up 13MB or roughtly 88% …
As I have been creating the Database Health project over the last couple of months, I have discovered that my favorite part of the whole project is the index defragmentation part of the project. This has turned out to be more challenging that I originally expected, but a lot more interesting than I expected as well. Yesterday I discovered a …
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 …
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 »
I added 2 new reports Top Cache Queries and Top CPU Queries into the Server Health Reports. Here is a screen shot of the latest report, the Top CPU Queries report: Enjoy….
I spent the day today at SQL Saturday in Vancouver BC. I met some fabulous SQL Server professionals, and presented 2 sessions. The first Session was on Unleashing Common Table Expressions in SQL Server. This was the second time that I presented this one, the first was at a SQL Saturday, the first time was SQL Saturday 108 in …
In preparation for my presentation at SQL Saturday in Vancouver BC tomorrow, I have updated the SQL Server Health Reports. As I was preparing for my presentation I discovered a few areas that I wanted to improve on the layout, sorting and overall presentation. Too late for the presentation tomorrow, but I started on the next new report to add …
The SQL Server Health Reports have been updated. As part of preparing for my SQL Saturday 114 presentation next weekend in Vancouver BC, I have updated the SQL Server Health Reports one more time. The latest update included lots of minor UI fixup making the reports look better. Including more summary detail on the main Health Report. Also, additional details …
In preparation for SQL Saturday 114 in Vancouver on March 17th, I have been updating and finalizing the SQL Server Health Reports. The upload today contains the largest number of changes since I created the SQL Server Health Reports. Before this update, the SQL Server Health Reports was just a bunch of reports for reporting on your database. One big change is the …