TempDB Best Practices

TempDB Best Practices

  1. TempDB should have as many data files as there are cores available to SQL Server, but only up to 8 data files. Too many TempDB data files can cause contention. Recommendation: Create 8 files and test from there on.
  2. TempDB should only have 1 log file. Extra log files will improve performance as they are written to sequentially.
  3. The data files for TempDB should all be the same size.
  4. TempDB data files and TempDB log files should be on separate disks.
  5. TempDB files should be on the fastest disks.
Advertisements

Author: Protiguous

C# Software Developer, Father, and seeker of Truth.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s