CPU is the workhorse of any SQL Server and Azure SQL. CPU handles not only core processing but also worker thread management and parallelism. And yet many of us don’t know the fundamentals beyond “SQL Server take cares of that for me”. So what happens to those CPUs when things go wrong? In this session, we’ll go deep into the internal behavior of SQL Server CPU, including the internal and external memory pressure, worker thread management, and how to troubleshoot CPU problems.