How many times did a procedure run, and how much CPU and IO did it use? The SSMS Resource Locking and Object Execution Statistics reports answer exactly that.
SQL SERVER – SSMS: Memory Usage By Memory Optimized Objects Report
Why is SQL Server using all the memory? In-Memory OLTP in SQL Server 2014 makes it trickier. This SSMS report shows memory used by memory optimized objects.
SQL SERVER – SSMS: Database Consistency History Report
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.