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 …
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 …
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 …
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 …
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 …
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 …
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, …
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 …
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 …