I'm in need of a bit of assistance.
I ran sp_Blitz on one of my SQL Servers and one of the results it returned is "1531 plans are present for a single query in the plan cache - meaning we probably have parameterization issues.".
I followed the link in the result.
I then ran sp_BlitzCache @ExpertMode = 1 to find queries with multiple plans but the #Plans and #Distinct Plans columns both return the value 1 for all rows.
How do I proceed to isolate the single query that has multiple plans?
Environment: SQL 2012 SP3 CU8
sp_BlitzCache version 5.7