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

SQL Server / SQL Server 2014

April 1^st, 2015

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

April 1^st, 2015

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.

By: 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, write at Simple Talk, SQLPerformance, and MSSQLTips, and have had the honor of speaking at more conferences than I can remember. In non-tech life, I am a husband, a father of two, a huge hockey and football fan, and my pronouns are he/him.