Sample Header Ad - 728x90

DBCC CHECKTABLE taking 15+ minutes to run on an empty table

7 votes
1 answer
1046 views
I have a database where DBCC CHECKTABLE on a number of small or empty tables taking over 15 minutes to run. When it finishes there are no failures or errors. The performance on everything else on the server is at a very acceptable form. There was nothing else running at the same time. I have also tried DBCC CLEANTABLE and updated stats with fullscan. I'm using SQL Server 2016 Enterprise Edition (13.0.5201.2) Example table: CREATE TABLE [Schema1].[Table1]( [col1] [int] NOT NULL, [col2] [nvarchar](100) NOT NULL, [col3] [xml] NOT NULL, CONSTRAINT [PK_1] PRIMARY KEY CLUSTERED ( [col1] ASC, [col2] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO
Asked by Russ960 (361 rep)
Oct 15, 2018, 10:00 PM
Last activity: Jun 13, 2019, 05:42 PM