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)
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