TempDB Database Checks for optimal performance

•          Is Tempdb files big enough?
•          Is Instant file initialization on?
•          Configured multiple tempDB Files?
•          Configured multiple data files?
•          Who is using tempdb space?

o   sys.dm_db_session_space_usage

o   sys.dm_db_file_space_usage

o   sys.dm_db_task_space_usage

o   sp_WhoIsActive

• Is Tempdb experiencing PageLatch issues?
• Are their contention in SGAM Pages?
• Is trace flag 1118 set?
• Are their contentions in DDL Operations?
• Check if Named constraints are created.
• Check if DDL statements that affect the table are not run after the temp table creation.
• Check if Temp object is not created by using dynamic SQL.
• Check if Temp object is created inside another object, such as a SP procedure.