sp_BlitzCache™ Result: Warnings in Execution Plans

SQL Server has included additional information in the execution plan to warn you about a potential problem with the query. This can be anything from tempdb spills to bad cardinality estimates to missing indexes.

How to Fix the Problem

Investigate what’s going on in SQL Server. The following query will identify the individual queries that are generating warnings. From there, it’s up to you.