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;
GO
SELECT size / 128.0 as sizeMB, *
FROM sys.database_files
WHERE type = 0
ORDER by type_desc;


Enroll Today!
SteveStedman5
SteveStedman5
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!