This is a dedicated watch page for a single video.
Identify the missing word(s) in the following sentence within the context of Microsoft Azure. The path most DBAs take to troubleshoot query performance is to first identify the problematic query (typically the query consuming the highest amount of system resources), and then retrieve that query’s execution plan. There are two scenarios. The query consistently performs poorly. The query performs well for some executions, but not others. [?] DMVs and plan warnings should only be used as a starting point for tuning your queries. It’s important to understand what your key queries are and build indexes to support those queries. Creating a(n) [?] without evaluating indexes in the context of each other is not recommended.