1. I have two sql instances (named and default) on same DB server machine, server is having 12 logical processors. Do I need to create 12 secondary tempdb files (ndf) on default and named sql instance? or is it sufficient if i create 12 tempdb ndf files on only default sql instance?
2. server is having 12 logical processors and I have created 12 tempdb files with equal size. As per below article is there any changes required on number of secondary tempdb files?
As a general rule, if the number of logical processors is less than or equal to 8, use the same number of data files as logical processors. If the number of logical processors is greater than 8, use 8 data files and then if contention continues, increase the number of data files by multiples of 4 (up to the number of logical processors) until the contention is reduced to acceptable levels or make changes to the workload/code.