Home

Hardware Instruction Support in SQL Server 2016

Introduction Back in 2016, Microsoft’s Bob Dorr consolidated a series of CSS posts about many low-level performance improvements in SQL Server 2016. One of these, How It Works: SQL Server 2016 SSE/AVX Support talks about how SQL Server 2016 added the use of SSE and AVX instructions in various code paths to improve performance when your processor supports one … Continue reading Hardware Instruction Support in SQL Server 2016

SQL Server Diagnostic Information Queries for November 2022

Introduction These are my SQL Server Diagnostic Information Queries for November 2022, aka my DMV Diagnostic Queries. They allow you to get a very comprehensive view of the configuration and performance of your SQL Server instance in a relatively short amount of time. This post is about my SQL Server Diagnostic Information Queries for November … Continue reading SQL Server Diagnostic Information Queries for November 2022


Follow My Blog

Get new content delivered directly to your inbox.

%d bloggers like this: