Top IO
Top IO Report
Category: Server Health
Sessions Submitted for SQL Saturday #120 Orange County CA
After being approved as a speaker at SQL Saturday 114 – Vancouver BC, and SQL Saturday 108 – Redmond WA, I have decided to give it another shot at SQL Saturday 120 in Orange County California. I have submitted 2 abstracts for sessions: The first one is titled Unleashing Common Table Expressions in SQL Server, and if accepted this will be …
Sessions Submitted for SQL Saturday #120 Orange County CA Read more »
Update available for the SQL Server Health Reports
I am now getting back into things after the holidays. Today I fixed a number of small layout related bugs in the SQL Server health reports. The updated reports are now available for download. Here is a sample of the Fragmented Indexes report.
2 Sessions Accepted for SQL Saturday 114 in Vancouver
I just checked the schedule and 2 of the sessions that I submitted for SQL Saturday 114 in Vancouver BC on March 17th have been accepted. The first one is on Unleashing Common Table Expressions in SQL Server, and the second session is Using SSRS reports to analyze SQL Server health. This should be fun!
Index Statistics Report added to the FREE SQL Server Health Reports
In preparation for an upcoming SQL Saturday presentation I have created another report to add to the FREE SQL Server Health reports project. The new Index Statistics Report is the 8th report in the series, intended to give DBA’s and database developers access to the information they need to analyze the health of their database. Here is a screen …
Index Statistics Report added to the FREE SQL Server Health Reports Read more »
Backup Set Report added to FREE Server Health Reports
In preparation for an upcoming SQL Saturday presentation I have created another report to add to the FREE SQL Server Health reports project. This report has been replaced with the Backup Report in the Database Health Project. The Backup Set Report has been added to the SQL Health Reports. The Backup Set Report is the 7th report to be added to the Database …
Backup Set Report added to FREE Server Health Reports Read more »
Database Size report added to SQL Health Reports
In preparation for a SQL Saturday presentation I have created another report to add to the FREE SQL Server Health reports project. The Database Size Report has been added to the SQL Health Reports. The Database Size Report is the 6th report to be added to the Database Health Reports package. The Database Health reports package is a FREE …
Database Size report added to SQL Health Reports Read more »
CPU Utilization Report added to SQL Server Health Reports
The CPU utilization report has been added into the SQl Server Health Reports. Here is a preview of the report.
Free – Duplicate Indexes Report – Updated
After creating and deploying the duplicate indexes report earlier today I discovered that although the report did exactly what it says, it didn’t do what I needed. The earlier duplicate indexes report only found indexes that were an exact match on the columns. And that is useful to track down, it didn’t point out indexes that were similar, but had additional columns. …
Free – New Duplicate Indexes Report added
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 …