A set of whithe papers on SQL Server 2005 best practices are available at http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/default.mspx. The topics covered are
- SQL Server 2005 Performance Tuning using Waits and Queues
- TEMPDB Capacity Planning and Concurrency Considerations for Index Create and Rebuild
- Loading Bulk Data into a Partitioned Table
- DBCC SHOWCONTIG Improvements and Comparison between SQL Server 2000 and SQL Server 2005
- Database Mirroring Best Practices and Performance Considerations
- Troubleshooting Performance Problems in SQL Server 2005
- SAP with Microsoft SQL Server 2005: Best Practices for High Availability, Performance, and Scalability
No comments:
Post a Comment