Performance and Stability Related Fixes in Post-SQL Server 2016 SP1 Builds

As of May 15, 2017, there have been three Cumulative Updates (CU) for the Service Pack 1 branch of SQL Server 2016. There have been a large number of hotfixes in each of these cumulative updates. If you are running on the SQL Server 2016 SP1 branch (which you should be by now), I really […]

SQL Server Diagnostic Information Queries for April 2017

This month, there are more minor updates for several of the SQL Server 2012 and newer version queries. There is also a new query that looks at the suspect pages table in msdb. Rather than having a separate blog post for each version, I have just put the links for all seven major versions in […]

SQL Server 2016 Service Pack 1 CU2 Released

On March 20, 2017, Microsoft released SQL Server 2016 Service Pack 1 CU2, which is Build 13.0.4422.0. This CU has 101 fixes in the public fix list, by my count. This is a pretty large CU, and if you look at the fix list in more detail, many of them are for pretty significant issues […]

Performance and Stability Related Fixes in Post-SQL Server 2014 SP2 Builds

As of April 17, 2017, there have been five Cumulative Updates (CU) for the Service Pack 2 branch of SQL Server 2014. There have been a large number of hotfixes in each of these cumulative updates. If you are running on the SQL Server 2014 SP2 branch, I really think you should be running the […]

SQL Server Diagnostic Information Queries for March 2017

This month, there are minor updates for the SQL Server 2012 and newer version queries. Rather than having a separate blog post for each version, I have just put the links for all seven major versions in this single post. There are two separate links for each version. The first one on the top left […]