SQL - Create additional TempDBs for each CPU

April 13, 2024

USE [master]

ALTER DATABASE [tempdb] ADD FILE ( NAME = N'tempdb2', FILENAME = N'D:\tempdb2.ndf' , SIZE = 1048576KB , FILEGROWTH = 204800KB )

GO

ALTER DATABASE [tempdb] ADD FILE ( NAME = N'tempdb3', FILENAME = N'D:\tempdb3.ndf' , SIZE = 1048576KB , FILEGROWTH = 204800KB )

GO

ALTER DATABASE [tempdb] ADD FILE ( NAME = N'tempdb4', FILENAME = N'D:\tempdb4.ndf' , SIZE = 1048576KB , FILEGROWTH = 204800KB )

GO

Tweet