O'Reilly logo

Designing SQL Server 2000 Databases by Syngress

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required