O'Reilly logo

Microsoft® SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition) by Scalability Experts, Inc.

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 9. Performance Analysis and Tuning

IN THIS CHAPTER

Physical Database Design, Analysis, and Tuning

Troubleshooting Locking and Blocking

Query Performance Tuning

Designing Applications for Performance

Performance Monitoring and Tuning Tools

Performance analysis and tuning is a challenging exercise that requires understanding of tools and techniques to measure and troubleshoot a performance issue. Some of the top performance killers include poor application design, inferior physical/logical database design, and costly/slow-running queries. Insufficient hardware resources and improper configurations of the operating system and the database system are some more causes of performance degradation.

SQL Server 2005 changes the 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