Change TempDB initial size and autogrowth

USE [master]

ALTER DATABASE [tempdb]

MODIFY FILE ( NAME = N'tempdb', SIZE = 1048576KB , FILEGROWTH = 204800KB )

GO 

Last Updated: April 13, 2024