Glenn’s Blog

SQL Server Diagnostic Information Queries for December 2022

Introduction These are my SQL Server Diagnostic Information Queries for December 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 December … Continue reading SQL Server Diagnostic Information Queries for December 2022

Is the Samsung 990 PRO Any Good?

Samsung recently released the highly anticipated Samsung 990 PRO M.2 NVMe PCIe 4.0 SSD. The 990 PRO is the successor to the very popular Samsung 980 PRO M.2 NVMe PCIe 4.0 SSD. This post will investigate whether the Samsung 990 PRO is any good or not. How Much Do These Drives Cost? The Samsung 990 … Continue reading Is the Samsung 990 PRO Any Good?

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.

Leave a Reply

%d bloggers like this: