Performance-Tuning Tools and Techniques
Solutions in this chapter:
■ Partitioning and Federated Database Servers
■ Optimizing Query Performance
■ Optimizing Database Performance with SQL Profiler
■ Optimizing Server Performance
Introduction
The success of nearly every application is determined by its reliability and performance. Squeezing every millisecond out of a solution is an ongoing task for most application designers and administrators. With SQL Server 2000, Microsoft continues to add performance enhancements to SQL Server with features such as auto-tuning capabilities that allow SQL Server to monitor activity and perform self-tuning tasks. Smaller organizations without dedicated administrators can enjoy greater out-of-the-box performance ...
Get Designing SQL Server 2000 Databases now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.