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 but run other tempdb checks to look for other common issues.

Any suggestion from Aireforge should be thoroughly tested before being implemented into production.

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