Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

sp_BlitzLock - try to get query plans instead of just collecting SQL Handles #3293

Closed
erikdarlingdata opened this issue Jun 26, 2023 · 0 comments · Fixed by #3296
Closed

sp_BlitzLock - try to get query plans instead of just collecting SQL Handles #3293

erikdarlingdata opened this issue Jun 26, 2023 · 0 comments · Fixed by #3296
Assignees
@erikdarlingdata
Labels
enhancement sp_BlitzLock

Comments

@erikdarlingdata
Copy link
Contributor

Is your feature request related to a problem? Please describe.
Right now we get a list of SQL Handles that you have to run BlitzCache to get. I think it would be more convenient to just try to get the query plan’s directly rather than adding a second step to the process.

Describe the solution you'd like
Put the plans in the output.

Describe alternatives you've considered
Doing more work

Are you ready to build the code for the feature?
Oui oui!
@erikdarlingdata erikdarlingdata self-assigned this Jun 26, 2023
erikdarlingdata added a commit to erikdarlingdata/SQL-Server-First-Responder-Kit that referenced this issue Jun 28, 2023
@erikdarlingdata
Get plans from cache
ff8a0f4 
Closes BrentOzarULTD#3293

Adds a result set that goes out to the plan cache to look for query plans for queries involved in deadlocks.
@erikdarlingdata erikdarlingdata mentioned this issue Jun 28, 2023
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@erikdarlingdata erikdarlingdata

Labels
enhancement sp_BlitzLock
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Get plans from cache erikdarlingdata/SQL-Server-First-Responder-Kit
1 participant
@erikdarlingdata