On-Demand Hotfix for Parallel Batch-Mode Deadlocks in SQL Server 2014

Today Microsoft released a critical, on-demand hotfix for customers using Columnstore indexes in SQL Server 2014. The hotfix addresses a scenario where a batch-mode scan that has gone parallel can deadlock, and the deadlock cannot be resolved automatically.

The hotfix can be downloaded from KB #3048751 and will bump SQL Server to 12.0.2488.

For more broad advice about hotfixes and cumulative updates for SQL Server 2014, see this blog post.

Aaron Bertrand

I am a passionate technologist with industry experience dating back to Classic ASP and SQL Server 6.5. I am a long-time Microsoft MVP, speak frequently at conferences, and write at SQLPerformance and MSSQLTips. I recently joined the team at Wayfair and hope to blog about some of the scale challenges I've already started helping to solve.