SQL Server Customer Advisory Team - SQL Server Best Practices

Enabling SQL Server customers to navigate the most challenging frontiers of large scale data management.

Whitepapers

TEMPDB Capacity Planning and Concurrency Considerations for Index Create and Rebuild

SQL Server Best Practices Article

Published: September 2007
Writers: Sanjay Mishra
Technical Reviewers: Tom Davidson, Mark Souza, Prem Mehra, Sunil Agarwal, Mike Ruthruff

Creating and rebuilding indexes are some of the most common database management tasks. Depending on application requirements and data volume changes, the database administrators develop periodic index maintenance schedules. Some of the key factors to consider while you devise an index maintenance plan are performance, concurrency, and required resources. SQL Server 2005 provides you with several options for index create and rebuild operations that you can use to effectively meet the requirements of performance, concurrency, and resources.

For more information, please refer to the TEMPDB Capacity Planning and Concurrency Considerations for Index Create and Rebuild whitepaper.

Published Nov 20 2007, 07:56 PM by denny.lee

Filed under: SQL, Index, Concurrency, Capacity

Comments

Troubleshooting and Tips - Cindy Gross said:

<div style="margin: 0in 0in 0pt; vertical-align: top"><span style="font-size: 10pt; color: black">So how do you&#160;estimate the amount of disk space needed for a ...

June 24, 2008 11:49 AM

About denny.lee

Denny Lee is a Senior Program Manager based out of Redmond, WA in the SQLCAT Best Practices Team. He has more than 12 years experience as a developer and consultant implementing software solutions to complex OLTP and data warehousing problems. His industry experience includes accounting, human resources, automotive, retail, web analytics, telecommunications, and healthcare. He had helped create the first OLAP Services reporting application in production at Microsoft and is a co-author of “SQL Server 2000 Data Warehousing with Analysis Services” and “Transforming Healthcare through Information [Ed. Joan Ash] (2008)”. In addition to contributing to the SQLCAT Blog, SQL Server Best Practices, and SQLCAT.com, you can also review Denny's Space (http://denster.spaces.live.com). Denny specializes in developing solutions for Enterprise Data Warehousing, Analysis Services, and Data Mining; he also has focuses in the areas of Privacy and Healthcare.