Home Forums SQL Server 2008 SQL Server Newbies Index maintenance job stuck in suspended state RE: Index maintenance job stuck in suspended state
coolchaitu
SSChampion
Points: 10332
More actions
September 26, 2016 at 11:05 am
#1903150
This job has 2 steps. It is stuck in the second step which does the DBCC CHECKDB. DBCC CHECKDB is in suspended state and the waittype it is showing is PAGEIOLATCH_SH. It is running in single thread and there is no blocking.