FIX: A deadlock occurs when you execute the sp_estimate_data_compression_savings stored procedure in SQL Server 2012

Symptoms

This issue occurs when the sp_estimate_data_compression_savings stored procedure is executed on a table that previously had a "text in row" table option set but no longer has a text, ntext, or image column type.

Additionally, you may receive the following error message in the SQL Server error log:
<Date Time>spid14s Deadlock monitor failed to resolve one or more deadlocks. Server may require restart to recover from this condition.
...
<Date Time> spid14s * Unresolved deadlock

Resolution

Cumulative Update information

The issue was first fixed in the following cumulative update of SQL Server.
Recommendation: Install the latest cumulative update for SQL Server

Workaround

To work around this issue, follow these steps:
  1. Alter the table to change an existing column or add a column so that the table now has a LOB type.
  2. Use sp_tableoption to remove in_row_limit.
  3. Change undo for the column operation.
After this, you can execute the sp_estimate_data_compression_savings stored procedure successfully.

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Properties

Article ID: 3069155 - Last Review: Aug 17, 2015 - Revision: 1

Feedback