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

Applies to: SQL Server 2012 DeveloperSQL Server 2012 EnterpriseSQL Server 2012 Standard

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


Status


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