Blitz Result: Missing Index Found in the Plan Cache
SQL Server can use indexes to make queries run much faster, and while it’s executing queries, it tracks which indexes it wishes would have been around. We can query the DMVs to discover what indexes SQL Server recommends, and we can also check the plan cache to identify which queries needed the index.
This part of our SQL Server sp_Blitz script checks the plan cache looking for resource-intensive queries that show missing index warnings.
To Fix the Problem
You could just create the index – but often that causes more problems than it solves. With each additional index, we may slow down inserts/updates/deletes, make backups take longer, make index rebuilds take longer, and more.
Review indexes holistically by checking out sp_BlitzIndex.