Chapter 4. Troubleshooting Query Performance
—Kalen Delaney and Craig Freedman
| In this chapter: | |
| Compilation and Optimization | 199 |
| Detecting Problems in Plans | 218 |
| Monitoring Query Performance | 221 |
| Query Improvements | 225 |
| Query Processing Best Practices | 273 |
| Summary | 275 |
As mentioned in Chapter 3, “Query Execution,” the SQL Server query processor consists of two components: the query optimizer and the query execution engine. In Chapter 3, we looked at details of many different types of query plans and discussed the process of query execution. In the first part of this chapter, we’ll talk about the query optimizer, which is responsible for generating good query plans. The optimizer includes subcomponents to gather statistics, perform cardinality estimation using ...
Get Inside Microsoft® SQL Server™ 2005: Query Tuning and Optimization 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.
