Secrets of SQL Server Webcast: TempDB: Performance and Manageability
TempDB: Performance and Manageability
Misconceptions and inconsistent advice on tempDB abounds. Even highly skilled DBAs cannot always agree on how to best configure tempDB. Part of the problem is that there is no single solution that can be applied to every situation.
How many files should tempDB have? Should it be on RAID 1? RAID 10? How about Solid State Drives (SSDs)?
This session will give you the tools to determine the optimal configuration for tempDB. Also covered is how to detect, prevent, and monitor for common tempDB performance problems.