Is there a query I can run to return query plans from sql plan cache that contain 1 or more warnings?


RedGate has a great article Checking the Plan Cache Warnings for a SQL Server Database on how to query the plan cache to find plans with warnings.

Ultimately the warnings will be stored in the XML query_plan column of sys.dm_exec_query_plan DMV.

Not the answer you're looking for? Browse other questions tagged or ask your own question.