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


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


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


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


Identyfikator artykułu: 3092702 — ostatni przegląd: 03.11.2015 — zmiana: 1