An attendee at my 42 tips session at SQLPass asked me a simple question. Our chat turned into a friendly lesson on understanding NUMA in SQL Server.
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.
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.
SQL SERVER – Using “High Performance” Power Plan for SQL Server
A simple, often missed setting on a new server: switch Windows to the High Performance Power Plan. Here is why it matters for SQL Server and where to set it.
Forced Parameterization: When It Cuts CPU and When It Hurts
Test forced parameterization against ad hoc compile pressure with query_hash counts, compilations per second, CPU, and parameter sensitivity.