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.
SQL SERVER – Finding Object Dependencies in SSMS – SQL in Sixty Seconds #071
Finding object dependencies in SSMS takes one right click on View Dependencies. I show how in this short SQL in Sixty Seconds video.
SQL SERVER – SSMS: Activity – All Blocking Transactions
Bengaluru traffic after a rainy day has a lot in common with blocked queries. I look at the All Blocking Transactions report in SSMS and what it shows.
SQL SERVER – Activity Reports – Dormant Sessions
A parent-teacher meeting tells me more than a report card. In the same way, the SSMS activity report on Dormant Sessions shows idle connections on your server.