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

Kehtib: SQL Server 2012 EnterpriseSQL Server 2012 DeveloperSQL Server 2012 Standard

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.

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.