This session will cover how and why you should configure tempdb, how to troubleshoot tempdb issues, and how to detect, resolve, and mitigate allocation contention issues by creating multiple data files, optimizing temporary object reuse, and using trace flag 1118.
(no tags)
Presented by Christian Bolton at SQLBits VI
WMV Video 231 MB