Hi,

There are some existing recommendations for the tempdb files. These two are most advised:

- If the server has more than 8 cores then start with 8 tempdb files; or

- The number of tempdb files should be 1/4 to 1/2 of the number of cores.

For the "proportional fill" algorithm it's vital the sizes and growths be equal for all files.

Regards,

IgorMi