CHAPTER 7
Analyzing Query Performance
The previous chapter showed how to gather query performance metrics. This chapter will show how to consume those metrics to identify long-running or frequently called queries. Then I’ll go over the tools built right into Management Studio so you can understand how a given query is performing. I’ll also spend a lot of time talking about using execution plans, which are your best view into the decisions made by the query optimizer.
In this chapter, I cover the following topics:
- How to analyze the processing strategy of a costly SQL query using Management Studio
- How to analyze methods used by the query optimizer ...
Get SQL Server Query Performance Tuning,Fourth 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.
