sp_BlitzLock - Speed up plan cache lookup of deadlock query plans

[erikdarlingdata]

Is your feature request related to a problem? Please describe.
SQL Server is picking some wack query plans when hitting the plan cache looking for SQL Handles related to deadlocked queries

Describe the solution you'd like
Drop qualifying rows into an intermediate temp table from sys.dm_exec_query_stats and then get query plans only with those rows.

Describe alternatives you've considered
Updating the #available_plans temp table to make it look like it has a ton of rows in it so the optimizer chooses and eager index spool plan. But that doesn't port to RDS, like we discovered with the #t temp table uses to encourage a parallel plan when reading the XML data.

Are you ready to build the code for the feature?
Yes I made it already when working through the same issue with sp_HumanEventsBlockViewer.

[pydss]

unsubscribe

…

On Tue, Aug 15, 2023 at 10:19 AM Brent Ozar ***@***.***> wrote: Closed #3311 <#3311> as completed via #3308 <#3308> . — Reply to this email directly, view it on GitHub <#3311 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACJBXINPP57MUTHFCFBW5MDXVOHR3ANCNFSM6AAAAAA2V3PXCU> . You are receiving this because you are subscribed to this thread.Message ID: <BrentOzarULTD/SQL-Server-First-Responder-Kit/issue/3311/issue_event/10098224336 @github.com>

[BrentOzar]

@pydss to unsubscribe, click the unsubscribe link in the email.