This post explains exactly what tempdb is responsible for -
Iain Kick - Not another tempdb post
And what to do to tune it, namely -
1) RAID level (& separate version)
2) Instant File Initialization
3) Trace Flag T1118
4) Pre Size tempdb
5) Split tempdb per processor core
No comments:
Post a Comment