Wednesday, December 13, 2006

SQL Server 2005 Performance tuning white papers

A set of whithe papers on SQL Server 2005 best practices are available at The topics covered are

  1. SQL Server 2005 Performance Tuning using Waits and Queues
  2. TEMPDB Capacity Planning and Concurrency Considerations for Index Create and Rebuild
  3. Loading Bulk Data into a Partitioned Table
  4. DBCC SHOWCONTIG Improvements and Comparison between SQL Server 2000 and SQL Server 2005
  5. Database Mirroring Best Practices and Performance Considerations
  6. Troubleshooting Performance Problems in SQL Server 2005
  7. SAP with Microsoft SQL Server 2005: Best Practices for High Availability, Performance, and Scalability