How increasing the number of tempdb data files reduces contention If you have one data file for the tempdb, you only have one GAM page, and one SGAM page for each 4 GB of space. Increasing the number of data files that have the same sizes for tempdb effectively creates one or more GAM and SGAM pages for each data file. More items... Dec 29, 2022