Main file updating failed operation canceled
If waiting is excessive and cannot be reduced by tuning the query (such as adding indexes), consider adjusting the cost threshold for parallelism or lowering the degree of parallelism.
This state controls when the recovery of Microsoft Distributed Transaction Coordinator (MS DTC) transactions occurs after SQL Server receives notification that the MS DTC service has become unavailable.
This state is used when SQL Server enables snapshot isolation by using the ALTER DATABASE statement.
Occurs during parallel queries while synchronizing in query processor in areas not related to the exchange iterator.
When you diagnose blocking issues, remember that external waits do not always imply that the worker is idle, because the worker may actively be running some external code. To view the tape status, query sys.dm_io_backup_tapes.
If a mount operation is not pending, this wait type may indicate a hardware problem with the tape drive.