Skip to main content
How can we help?
< All Topics
Print

Incorrect tempdb configuration

Best practice for the number of temp files is to set the number of temp files to the same amount as the number of logical processors in the server for servers with 8 logical processors or less. For servers with more than 8 logical processors, the number of temp files should be 8.

This is a very generic guideline and might not apply to all environments.

To query the Performance Store database for servers with an incorrect tempdb configuration, use:

select s.server_name, s.logical_processors_count, s.number_of_temp_files
from dbo.v_servers s
where (s.number_of_temp_files > 8) or (s.number_of_temp_files != s.logical_processors_count and s.logical_processors_count <= 8) or (s.number_of_temp_files != 8 and s.logical_processors_count > 8)

The alert will be visible on the Latest stats dashboard.

To exclude specific servers from this alert, see how to use the dbo.team_alert_exclude table in Alerting.

Table of Contents