SQL Server 2014 RTM Cumulative Update 2

Microsoft has released SQL Server 2014 RTM Cumulative Update 2, which is Build 12.0.2370.0. It has 48 hotfixes in the public fix list. This is one of the more interesting fixes: FIX: Intense query compilation workload does not scale with growing number of cores on NUMA hardware and results in CPU saturation in SQL Server […]

Upcoming SQLskills Training Classes

As Paul announced last week, SQLskills has revamped the previous IE1 and IE2 classes to focus even more on performance tuning and optimization. If you are interested in how to select and configure database hardware for various workloads as well as how to configure your operating system and SQL Server for the best performance and […]

Learn About SQL Server Hardware This October in Chicago

On October 9-10, 2014, I will be teaching IEHW: Immersion Event on SQL Server Hardware in Chicago, IL. This is a great opportunity for you to learn how to properly select and configure your server hardware and storage subsystem to get the best performance and scalability for the lowest SQL Server 2012/2014 licensing costs. You […]

SQL Server Diagnostic Information Queries for June 2014

I added several new queries this month to all five versions of the script. I also spent quite a bit of time getting all five versions back in synch as much as possible, as far as my comments and other minor differences that had cropped up over the last few months. Rather than having a […]