(Hareesh Gottipati) In order to reduce Tempdb contention one of the best practices is to maintain multiple sized Tempdb data files, matching the number of processors and up to a maximum of 8.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help