Analyzing I/O Performance from SQLSaturday #300

I had the opportunity to present Analyzing I/O Performance at SQLSaturday #300 in Kansas City, MO on September 13, 2014. I think the session went well, judging by the amount and type of questions that I got during and after the presentation, along with the written feedback forms that I read afterwards. The overall event […]

SQL Server Diagnostic Information Queries for September 2014

I revised a number of the queries this month in all five versions of the script. I have also added several new queries to the SQL Server 2012 and SQL Server 2014 versions of the script. Here are the current query counts for each version: SQL Server 2014         72 Queries SQL Server 2012         69 Queries […]

SQL Server 2012 SP1 CU12 and SP2 CU2 Released

Microsoft has released SQL Server 2012 Service Pack 1 CU12 (Build 11.0.3470) and SQL Server 2012 Service Pack 2 CU2 (Build 11.0.5548). Both of these CUs (which were released on the same day) have a significant number of valuable hotfixes. SP1 CU12 has 14 hotfixes, and SP2 CU2 has 50 hotfixes. Needless to say, I […]

Intel Xeon E5-2600 v3 Product Family and SQL Server

Intel finally announced their latest 22nm Xeon E5 v3 Product Family (Haswell-EP) today, which includes 27 different processor models (SKUs) for both one and two-socket servers. These SKUs go from four-core models, all the way up to eighteen-core models. This is an Intel Tock release, meaning a new microarchitecture, but still using the 22nm manufacturing […]