A CPU scheduler waiting on disk shows pending disk IO on its scheduler. This post reads sys.dm_os_schedulers once and in a short sampling loop, then confirms the result with file latency.
Reading Performance Counters in T-SQL Without Misreading Them
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.