njohnson

So much this. Please, please add this soon.

I agree, this feature would be very useful. While I understand that the numeric plan-hashes in DPA are "easier to read" than the binary/hexadecimal handles that SQL Server assigns to the plans, it would be extremely valuable for us as DPA users to say "This is a bad plan, show me the handle so I can tell SQL to get rid of…

The work-around to do this, to query the DPA repository database, is like so. USE dpa_repository; SELECT * FROM (<br /> SELECT * FROM dpa_repository.ignite.CONSPH_1<br /> UNION ALL<br /> SELECT * FROM dpa_repository.ignite.CONSPH_2<br /> --UNION ALL<br /> --SELECT * FROM dpa_repository.ignite.CONSPH_3<br /> UNION ALL<br />…