Chapter 9. Performance Analysis and Tuning
IN THIS CHAPTER
• Physical Database Design, Analysis, and Tuning
• Troubleshooting Locking and Blocking
• 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 ...
Get Microsoft® SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition) 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.
