TempDB Contention

This warning has been raised because Aireforge Studio has detected active queries in a wait state for tempdb resources.

Suggested Action

Be careful about knee-jerk reactions and run other tempdb checks to look for other common issues.

Further Reading

​Recommendations to reduce allocation contention in SQL Server tempdb database | Microsoft Support

​TempDB Database | Microsoft Docs