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: