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
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. We recommend that you download and install the latest cumulative updates 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.
Свойства

ИД на статията: 3069155 – Последен преглед: 08/17/2015 19:05:00 – Редакция: 2.0

Microsoft SQL Server 2012 Service Pack 2, Microsoft SQL Server 2014 Service Pack 1

  • kbqfe kbfix kbsurveynew kbexpertiseadvanced KB3069155
Обратна връзка