FIX: It takes a longer time than earlier versions of SQL Server when you run DBCC CHECKDB in SQL Server 2012 or SQL Server 2014

Symptoms

Assume that you have a table that has lots of partitions in Microsoft SQL Server 2012 or SQL Server 2014. When you run DBCC CHECKDB against the database that contains the table, it takes a much longer time to complete than in earlier versions of SQL Server. Additionally. a high CPU usage occurs.

Note You can run the following command to check the number of the partitions that exist per object/index:
select COUNT(*) from sys.system_internals_partitions GROUP BY object_id, index_id


Resolution

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

Status

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

Özellikler

Makale No: 3092702 - Son İnceleme: 3 Kas 2015 - Düzeltme: 1

Geri bildirim