NUMA in SQL Server came up in a lunch break chat at SQLPass, during my 42 tips session. An attendee asked what NUMA is and when SQL Server got it. Here is the answer I gave, with the history.
SQL SERVER – Who is consuming CPU on my SQL Server?
A corridor question after my MODS session: who is consuming CPU on my SQL Server? Here is how I would find out using SQL Server itself.
SQL SERVER – Fix: SQL Server CPU Schedulers Offline
A reader’s 80 core server was not using all cores in SQL Server. Here is how to spot CPU schedulers offline and the usual reasons behind them.
SQL Server Scheduler and Operating System Scheduling: Notes
The SQL Server scheduler decides which ready work gets processor time, on top of the operating system’s own thread scheduling. Tested queries on SQL Server 2025 show runnable, running and suspended tasks under load, and the permission each view needs.
How to Find Queries Running in Parallel in SQL Server
To find queries running in parallel, read max_dop and the CPU to elapsed ratio from the query stats view, then confirm with the plan XML. This post tests both on a two million row table. It also explains why the same query stays serial until its cost passes the threshold.
SQL SERVER – Why Haven’t You Disabled CPU Power Saving Yet?! – Notes from the Field #087
Notes from the Field #087: why you should disable CPU power saving on your SQL Server, and how this one setting can quietly slow queries.
.jpg)
Great Indian Developer Summit 2015: Three SQL Sessions and a CPU Check
Great Indian Developer Summit 2015 brought me to Bangalore and Hyderabad for three SQL Server sessions. This page keeps the dates, topics and photos. It also adds a CPU check I would start with today, tested on SQL Server 2025, because one session was about CPU performance.