Run the following query to identify queries that cause high CPU usage and that contain at least one missing index in the query plan: Review the execution plans for the queries that are identified, and tune the query by making the required changes. Having created and started the event session, we use it as a custom metric in SQL Monitor. Does Cosmic Background radiation transmit heat? From the Execution Count column in Figure 2, we can see that over the timeframe being investigated, this query ran only a single time. Monitor failed and long-running MS SQL Server jobs Data conversions and data loads from various databases and file structures . How can I force a query to not use a index on a given table? [command_text] ----- It will display the Stored Procedure's Name. Suspicious referee report, are "suggested citations" from a paper mill? For example, using