This alarm is raised when Tempdb is experiencing contention on:
When the alarm is raised
Review the balance of logical processors to Temp data files.
|Logical Processors||Tempdb data files|
|Up to 8 logical processors:-||Consider the same number of Tempdb data files as logical processors.|
|More than 8 logical processors:-||Consider 8 Tempdb data files.|
If contention continues then increase the number of data files by multiples of 4 (up to the number of logical processors) until the contention is reduced to acceptable levels or make changes to the workload/code.