Select Page

TempDB Sized Differently

If you have multiple TempDB files, you will want to be sure that they are sized the same, otherwise the larger file will get excessive amount of data stored and more I/O.

Sizing all your TempDB files the same will help balance the workload between them more evenly. This applies the the use of multiple TempDB data files; Log files are not included in this.

use tempdb;
SELECT size / 128.0 as sizeMB, *
FROM sys.database_files
WHERE type = 0
ORDER by type_desc;