How to configure tempdb in SQL Server

The tempdb system database comes out-of-the-box with settings that don't perform well for many production workloads. In this video, Microsoft Certified IT Professional Jon Seigel explains three important considerations to configure tempdb for optimal performance, including an in-depth discussion about how to choose the number of data files to create. Blog post: http://voluntarydba.com/post/2013/12/10/Standard-configuration-of-tempdb.aspx How to enable Instant File Initialization: http://www.youtube.com/watch?v=XW-O_a8mZgs Read more about sys.dm_os_waiting_tasks: http://technet.microsoft.com/en-us/library/ms188743.aspx Read more about sys.dm_os_wait_stats: http://technet.microsoft.com/en-us/library/ms179984.aspx Read more about DBCC SQLPERF: http://technet.microsoft.com/en-us/library/ms189768.aspx sys.dm_os_waiting_tasks query to find PAGELATCH_* waits: http://jsstatic.net/Content/SqlScripts/Show%20waiting%20tasks.sql Visit my channel for more database administration videos: https://www.youtube.com/voluntarydba Subscribe to get notified about my latest videos: https://www.youtube.com/voluntarydba?sub_confirmation=1 Read additional content on my blog: http://voluntarydba.com Follow on Twitter: https://twitter.com/voluntarydba Like on Facebook: https://facebook.com/voluntarydba