Chapter 14

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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.