On July 23, 2024, Microsoft released SQL Server 2022 Cumulative Update 14. This is Build 16.0.4135.4. By Microsoft’s count, there are 12 public fixes and improvements in this CU, so it has a lower than average number of fixes. This is not unexpected since SQL Server 2022 has been out for about 18 months now. … The post SQL Server 2022 Cumulative Update 14 first appeared on Glenn's SQL Server Performance ..read more

Introduction These are my SQL Server Diagnostic Information Queries for July 2024, 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 July 2024. There are separate versions of these T-SQL queries for SQL Server 2005 through SQL Server 2022. Please make sure you download and use the appropriate T-SQL script for your version of SQL Server. SQL Server Diagnostic Information Queries for July 2024 I als ..read more

On July 9, 2024, Microsoft released SQL Server 2019 CU27 + GDR. This is Build 15.0.4382.1. By Microsoft’s count, there are 2 security fixes in this GDR. As usual, this GDR is being pushed out by Microsoft Update. Also as usual, I have updated the SQL Server 2019 version of my SQL Server Diagnostic Information Queries to cover this. It is always a good idea to read through the GDR KB article to see more information about each fix. This will help you decide whether to push your organization to get the latest CU + GDR deployed or not. I have a blog post that might help you with this argument: Wh ..read more

On June 13, 2024, Microsoft released SQL Server 2019 Cumulative Update 27. This is Build 15.0.4375.4 By Microsoft’s count, there are 31 public fixes or improvements in this CU, so it has a slightly above average number of fixes and improvements. This CU is once again on time (based on Microsoft’s public guidance about how SQL Server is serviced), so kudos to Microsoft for staying on schedule for this CU. It is always a good idea to read through the CU KB article to see more information about each fix and improvement. This will help you decide whether to push your organization to get the latest ..read more

Introduction These are my SQL Server Diagnostic Information Queries for June 2024, 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 June 2024. There are separate versions of these T-SQL queries for SQL Server 2005 through SQL Server 2022. Please make sure you download and use the appropriate T-SQL script for your version of SQL Server. SQL Server Diagnostic Information Queries for June 2024 I als ..read more

On May 16, 2024, Microsoft released SQL Server 2022 Cumulative Update 13. This is Build 16.0.4125.3. By Microsoft’s count, there are 15 public fixes and improvements in this CU, so it has a lower than average number of fixes. This is not unexpected since SQL Server 2022 has been out for about 18 months now. It is always a good idea to read through the CU KB article to see more information about each fix and improvement. There are a number of interesting fixes and improvements in this CU. I continue to be somewhat frustrated by the very sparse documentation for many fixes and improvements. Pers ..read more

Introduction These are my SQL Server Diagnostic Information Queries for May 2024, 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 May 2024. There are separate versions of these T-SQL queries for SQL Server 2005 through SQL Server 2022. Please make sure you download and use the appropriate T-SQL script for your version of SQL Server. SQL Server Diagnostic Information Queries for May 2024 I also h ..read more

On April 11, 2024, Microsoft released SQL Server 2019 Cumulative Update 26. This is Build 15.0.4365.2 By Microsoft’s count, there are 19 public fixes or improvements in this CU, so it has a about an average number of fixes and improvements. This CU is once again on time (based on Microsoft’s public guidance about how SQL Server is serviced), so kudos to Microsoft for staying on schedule for this CU. This CU also has the security fixes from the CU25 + GDR release from April 9, 2024. It is always a good idea to read through the CU KB article to see more information about each fix and improvement ..read more

On April 9, 2024, Microsoft released SQL Server 2019 CU25 + GDR. This is Build 15.0.4360.2. By Microsoft’s count, there are 2 security fixes in this GDR. As usual, this GDR is being pushed out by Microsoft Update. Also as usual, I have updated the SQL Server 2019 version of my SQL Server Diagnostic Information Queries to cover this. It is always a good idea to read through the GDR KB article to see more information about each fix. This will help you decide whether to push your organization to get the latest CU + GDR deployed or not. I have a blog post that might help you with this argument: W ..read more

Introduction These are my SQL Server Diagnostic Information Queries for April 2024, 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 April 2024. There are separate versions of these T-SQL queries for SQL Server 2005 through SQL Server 2022. Please make sure you download and use the appropriate T-SQL script for your version of SQL Server. SQL Server Diagnostic Information Queries for April 2024 I ..read more