One or more of your top poorly performing queries also have missing indexes. This can cause additional CPU usage and I/O problems and may be the only reason this query is showing up in the top poorly performing queries.

To help you identify high value missing indexes (Impact >= 70%), we’ve added a column to sp_BlitzCache and sp_BlitzQueryStore that lists out all the missing indexes for a query.

CLICK ME FOR ONE WEIRD TRICK OR MAYBE A FEW WEIRD TRICKS WHO KNOWS IT’S HALLOWEEN

This doesn’t mean you should add every index SQL recommends, but it’s a good place to find opportunities to tune indexes. Think of it as SQL Server’s little cry for help.

How to Fix the Problem

Run sp_BlitzIndex to determine which indexes you’re missing on a database by database basis.

To find the queries that are generating missing index recommendations, you can run the following query:

Menu
{"cart_token":"","hash":"","cart_data":""}