Advertisement
Published in:
2018 | OriginalPaper | Chapter
7. Analyzing Query Performance
Activate our intelligent search to find suitable subject content or patents.
Select sections of text to find matching patents with Artificial Intelligence. powered by
Select sections of text to find additional relevant content using AI-assisted search. powered by
Abstract
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 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.