Regular Session

TempDB: Performance and Manageability [DBA-303]

Speaker: Robert Davis

Duration: 75 minutes

Track: Database Administration (DBA)

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.


Join us on Twitter

cage-aids
cage-aids
cage-aids
cage-aids