TempDb Files Uneven number

by SkyPool392   Last Updated July 03, 2018 18:06 PM

Our ProdIT team added uneven number Tempdb files. We currently have 17 tempdb files instead of 16. We cannot change anything until next patching period in next month, I am seeking to make it much earlier. What are the negative consequences of having uneven tempdb files undividable by 2. I heard general rules, we should have even number.

ALTER DATABASE [tempdb] ADD FILE ( NAME = N'tempdev2', FILENAME = N'G:\tempdb1.ndf' , SIZE = 12288000KB , MAXSIZE = UNLIMITED, FILEGROWTH = 0 )
GO
ALTER DATABASE [tempdb] ADD FILE ( NAME = N'tempdev3', FILENAME = N'G:\tempdb2.ndf' , SIZE = 12288000KB , MAXSIZE = UNLIMITED, FILEGROWTH = 0 
..GO
ALTER DATABASE [tempdb] ADD FILE ( NAME = N'tempdev3', FILENAME = N'G:\tempdb17.ndf' , SIZE = 12288000KB , MAXSIZE = UNLIMITED, FILEGROWTH = 0 


Related Questions


SQL Tempdb files Solid state on Same drive?

Updated June 26, 2018 03:06 AM

Tempdb Add files require Restart

Updated June 28, 2018 17:06 PM