Chat now with support
Chat with Support

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

Tempdb File Location

This alarm is raised when Tempdb files are in the same location as other database files and I/O activity is significant and more than one drive is available.

When the alarm is raised

Consider moving Tempdb to a volume that has no other databases on it so that potential problems are easier to isolate.

For example, consider isolating Tempdb data files to their own logical drive. Move the Tempdb log files with the user database log files where there should be enough free disk space for unexpected auto grow events.

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