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
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.