Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Management Pack for SCOM User Guide

Tempdb Contention

This alarm is raised when Tempdb is experiencing contention on:

  • Page free space (PFS)
  • Global allocation map (GAM)
  • Shared global allocation map (SGAM)

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.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating