Ever seen a database taking a long time to create? Tim Radney explains in simple words why it happens, based on a real question from a forum.
Current Activity Section: Performance Dashboard Reports Explained
The Current Activity section of Performance Dashboard shows what is running right now, split into user requests and user sessions, taken from two DMVs.
SQL SERVER – SSMS: Performance Dashboard Reports – Home Page details
Here are the Performance Dashboard home page details: lots of server information in one view. I walk through its six sections one after another.
SQL SERVER – SSMS: Performance Dashboard Installation and Configuration
Performance Dashboard reports are free custom reports from the Microsoft SQL Server Support team. Here is the Performance Dashboard installation and setup in SSMS.
Reading Connection Details in Code: APP_NAME, HOST_NAME and Logins
An audit row blamed the wrong machine because a label was treated as proof. Here is which connection values you can trust, and which you cannot.
SQL SERVER – Connecting to Azure Storage with SSMS
Connecting to Azure Storage from SSMS takes a few simple steps from Object Explorer. I also show where to find your storage account name and key.
SQL SERVER – SSMS: Index Usage Statistics, Physical Statistics & User Statistics
Creating indexes is a science, not rules of thumb. I look at the SSMS reports for Index Usage Statistics, Physical Statistics and User Statistics.
SQL SERVER – Using the SSIS Term Extraction for Data Exploration – Notes from the Field #046
Tim Mitchell shows how SSIS Term Extraction helps with data exploration, so you understand the source data better before you build an ETL process.
SQL SERVER – SSMS: Resource Locking and Object Execution Statistics Report
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 – Location of Natively Compiled Stored Procedure and Naming Convention
Why is it called a natively compiled stored procedure when the code is T-SQL? I explain, and show a DMV query that finds where its DLL is loaded from.










