patternsqlMinor
Help with wait type CHECK_TABLES_THREAD_BARRIER
Viewed 0 times
waitwithcheck_tables_thread_barrierhelptype
Problem
I have a 2016 SQL Server freshly built - 13.0.5149.0 - OS 2016 (Microsoft Windows NT 6.3 (14393)). The environment is VMWare. No SQL Server HA configuration.
It has a problem where CheckDB "stops" with a wait type of CHECK_TABLES_THREAD_BARRIER. It has happened twice on 2 different databases. I don't see much listed on online resources for what to do with this wait. Microsoft lists "TBD" on information. This is a non production proof of concept environment for an upgrade.
Can anyone provide any insight or next steps?
It has a problem where CheckDB "stops" with a wait type of CHECK_TABLES_THREAD_BARRIER. It has happened twice on 2 different databases. I don't see much listed on online resources for what to do with this wait. Microsoft lists "TBD" on information. This is a non production proof of concept environment for an upgrade.
Can anyone provide any insight or next steps?
Solution
Although I don't have any info on this yet in my waits library (will be fixed soon), you're likely hitting this hang when CHECKDB has hit an error state and it waiting for the various threads to finish running.
This is a rare, known issue that Microsoft is investigating but as yet has not identified or fixed.
Thanks
This is a rare, known issue that Microsoft is investigating but as yet has not identified or fixed.
Thanks
Context
StackExchange Database Administrators Q#226262, answer score: 3
Revisions (0)
No revisions yet.