Like a doctor looking for patterns in symptoms, the Database Consistency History report in SSMS shows the history of consistency checks on a database.
SQL SERVER – SSMS: Backup and Restore Events Report
Backups look trivial until the day a disk crashes. The Backup and Restore Events report in SSMS shows the history of those tasks for a database.
SQL SERVER – SSMS: Disk Usage Report
After a doctor joke, we move from server level reports to database level ones, starting with the Disk Usage report in SSMS.
SQL SERVER – SSMS: Top Object and Batch Execution Statistics Reports
Just like sports stats, SSMS has head-to-head numbers for your server. Here is a tour of the Top Object and Batch Execution Statistics Reports.
SQL SERVER – SSMS: Top Queries by CPU and IO
My father’s office PC started my love for computers and processors. That story leads to the SSMS reports on Top Queries by CPU and IO.
SQL SERVER – SSMS: Top Transaction Reports
A story about my daughter’s school drawing contest leads into the Top Transaction reports in SSMS and what they tell you about your server.
SQL SERVER – SSMS: Transaction Log Shipping Status Report
Like timber floating downstream, log shipping moves logs from one server to another. Here is how to read the Transaction Log Shipping Status report in SSMS.