TechNet has made availabe a whitepaper that deals with Online Indexing Operations in SQL Server 2005. Introduced in SQL Server 2005 Enterprise Edition, the online index feature provides a powerful way to perform maintenance operations such as rebuilding or creating indexes in a production system without sacrificing DML concurrency. This paper provides a detailed discussion of the index process and provides guidelines and best practices for implementing this feature in a production environment.
Included in this document:
• Introduction
• Data Structures and Concepts
• Overview of the Online Index Build Algorithm
• Capacity Planning and Concurrency Considerations for Index Create and Rebuild Operations
• Online Index Best Practices
• Conclusion
• Appendix A: Performance Study
• Appendix B: Diagnostics
• Appendix C: Log Measurement Script
• Appendix D: Online Index Limitations
Download this whitepaper (Word doc,25 pages) here: http://www.microsoft.com/technet/prodtechnol/sql/2005/onlineindex.mspx
No comments:
Post a Comment