Most RecentMost ViewedMost LikesTempdb misconfiguration when SQL Server fails to create a secondary data file First published on MSDN on Nov 10, 2016 One of the tempdb best practices when you configure SQL Server is to create additional data files for tempdb according the number of logical processor per NUMA node up to eight.