Read SQL Server performance counters with two timed samples, a proper ratio base, and a concise workload and memory dashboard.
SQL SERVER – NOLOCK with DMVs
NOLOCK with DMVs is not a blanket reassurance against monitoring waits. A customer asked about omitting the hint.
SQL SERVER – Session Counts by Database Are Not Lock Row Counts
Total Sessions and total lock rows answer different questions. My original query counted lock rows under a session label.
System Threads Outside Max Worker Threads in SQL Server
System threads outside max worker threads run background work that the setting does not limit, as the documentation says. This post counts the background tasks with two read-only queries and explains what that means for sizing the setting.
Size and Rows of Each Table in SQL Server, Indexes Included
To list the size and rows of each table, add up the pages from sys.dm_db_partition_stats and split them into data, index and unused space. This post shows three traps in the common join query and checks the corrected result against sp_spaceused.
MAX Columns Ever Existed in Table – SQL in Sixty Seconds #182
Earlier I wrote about SQL SERVER – MAX Columns ID Used in Table and lots of people asked me to create a video on this topic. Let us see the video.
SQL SERVER – High Frequency Cached Query Counts and Statement Metrics
I measure High Frequency cached statements with decimal executions-per-second arithmetic. A customer wanted to identify the busiest queries.