Chat now with support
Chat with Support

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

Tempdb Number of Files

This alarm is raised when the number of files in the Tempdb database is less than the number of processors and the SQL Server is experiencing contention on Tempdb.

When the alarm is raised

To ease contention consider increasing the number of Tempdb files to one Tempdb file per processor. Thus increasing the number of Tempdb files increases the number of physical I/O operations that SQL Server can push to the disk at any one time. The more I/O that SQL Server can push down to the disk level, the faster the database will run.

It is important to configure the files at the same initial size and with the same growth settings. That way, SQL Server will manage an even distribution of data across the files.

Note: This alarm is applicable to SQL Server 2005 and above.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating