If the number of logical processors is greater than eight (8), use eight data files. If contention continues, increase the number of data files by multiples of four (4) up to the number of logical processors until the contention is reduced to acceptable levels. Alternatively, make changes to the workload or code. Reference: https://docs.microsoft.com/en-US/troubleshoot/sql/performance/recommendations-reduce- allocation-contention