You are here: Home >> Database Maintenance >> Comprehensive tempdb blog post series
Over the last few weeks Sunil Agarwal (from the SQL Storage Engine team) has posted a great series of blog articles about tempdb and the version store, over on my old stomping ground – the Storage Engine blog. The articles are well worth reading – the links are:
- Managing tempdb part 1 and part 2
- Version store – what is it?
- Version store example
- Version store logical structure
- Version store growth and removing stale versions
- tempdb configuration
- tempdb troubleshooting: IO bottlenecks
- tempdb troubleshooting: allocation bottlenecks
- tempdb troubleshooting: DDL bottlenecks
- tempdb troubleshooting: out-of-space
Enjoy!
本文转自 Fanr_Zh 博客园博客,原文链接:http://www.cnblogs.com/Amaranthus/archive/2013/04/11/3014018.html,如需转载请自行联系原作者