SQL Server Diagnostic Information Queries for April 2015

I revised several of the queries this month in only the SQL Server 2012 and 2014 versions of the script.  As usual, the main enhancements are additional comments and documentation about the queries, including more information about how to interpret the results.  Since SQL Server 2008 R2 and older are out of Mainstream support from […]

SQL Server 2014 RTM Cumulative Update 7 Available

Microsoft has released SQL Server 2014 RTM Cumulative Update 7, which is Build 12.0.2495. This cumulative update has 41 public hot fixes, several of which look pretty significant. I have updated my recent blog post Performance and Stability Related Fixes in Post-SQL Server 2014 RTM Builds to include CU7. It probably comes as no surprise […]

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

As of April 18, 2016, there have been thirteen Cumulative Updates (CU) for the RTM branch of SQL Server 2014. There have been a fairly high number of hotfixes in every one of these Cumulative Updates, as more people are using SQL Server 2014. If you are running SQL Server 2014 RTM, I really think […]

Beware of the Native Microsoft NVMe Driver!

Non-Volatile Memory Express (NVMe) is a specification for accessing solid-state drives (SSDs) attached through the PCI Express (PCIe) bus. It gives lower storage latency and much higher queue depths. Even though this technology is most relevant for server workloads, there are also some affordable new NVMe devices meant for client devices and workloads. A good […]