Questions tagged [dbcc-checktable]

Use the dbcc-checktable tag for questions about how to implement, understand, and diagnose issues with the SQL Server DBCC CHECKTABLE command

Filter by
Sorted by
Tagged with
2
votes
2answers
63 views

DBCC consistency error in SQL Server

I ran DBCC CheckDB in our Production SQL Server 2014. It reported back with one consistency error: Failed:(-1073548784) Executing the query "DBCC CHECKDB(N'MYDB') WITH NO_INF..." failed ...
0
votes
1answer
37 views

Is there any specific differences on table level integrity check between DBCC CHECKDB and DBCC CHECKTABLE?

I've faced with allocation error in one of our databases while running DBCC CHECKDB on it. It throws below-mentioned error: Msg 8947, Level 16, State 1, Line 5 Table error: Multiple IAM pages for ...
0
votes
2answers
148 views

What causes DBCC CHECKTABLE to return "session is in the kill state"?

A scheduled job step ran DBCC CHECKTABLE on a table but returned the following error: Cannot continue the execution because the session is in the kill state. [SQLSTATE HY000] (Error 596). The step ...
0
votes
1answer
25 views

Overhead associated with DBCC CHECKTABLE?

Have a logshipped VLDB and don't run DBCC CHECKDB on primary due to the long running periods of high CPU and tempdb usage. Have read about DBCC CHECKTABLE as a possibility for a more granular data ...
7
votes
1answer
497 views

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

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 ...
1
vote
1answer
464 views

Why does DBCC CHECKTABLE WITH TABLERESULTS only report Error 8990 on corrupt tables?

I have a production VLDB that I'm using Paul Randal's guidance on to spread DBCC CHECKDB workload over a week. I'm logging the results of DBCC CHECKTABLE WITH TABLERESULTS and DBCC CHECKALLOC WITH ...
2
votes
0answers
902 views

DBCC TABLE CHECK command won't stop

We have a SQL Server 2014 with 140 user databases, each of which have approx. 180 tables. A maintenance plan was scheduled for once a week but it was discovered that the Check Database Integrity (DBCC ...
6
votes
1answer
158 views

Table with persisted computed CLR originated data marked with has_unchecked_assembly_data = 1, but DBCC CHECKTABLE does not unset this same flag

We have an OrderLines table with columns: Quantity int not null QtyCancelled int not null QtyBackorder int not null QtyPicking int not null QtyPacking int not null QtyShiped int not null with ...
2
votes
1answer
328 views

VLDB - Create SQL DB Snapshot And Run Granular DBCC CHECKDB Commands

I have a 25TB db (SQL2008 Enterprise SP4) that appears to not have had CHECKDB run on it in production. No idea if it was run against a restored backup somewhere at sometime. Right now I don't have ...
0
votes
0answers
139 views

DBCC REPAIR_REBUILD adds rows

SQL Server 2008 R2, an update corrupted my table somehow, likely to do with the storage subsystem. I am on a dev database, so aren't overly concerned about losing data, it isn't business critical. But ...