Processor Selection for SQL Server

Over the past six years, I have written a number of articles and blog posts about processor selection for SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017. To make them easier to find for others (and myself), I have put together a list of links, in reverse chronological order. I […]

SQL Server Cumulative Update Highlights

I have a series of blog posts (that I try to keep updated over time) that list I what I consider to be the more important hotfixes in each cumulative update for the respective branch of code for that version of SQL Server. In order to make it easier for people (and myself) to find […]

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

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

SQL Server Diagnostic Information Queries for July 2015

This month, I have added a couple of new queries for SQL Server 2016, including one that uses QueryStore. This version will continue to be improved with more SQL Server 2016-specific  queries and columns in existing queries over the next few months. Since SQL Server 2008 R2 and older are out of Mainstream support from […]

Using Windows Resource Monitor to Find Unusual Performance Bottlenecks

I recently had an interesting issue with a new SQL Server 2014 Enterprise Edition instance that was going to be hosting about 200 user databases that each use the SQL Server Filetable feature. The reported problem was that this new instance was taking two-three times longer to restore each full database backup than the restores […]