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.

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

sp_BlitzLock: Add a check for the rollup section for deadlocks with background processes #3329

Closed
erikdarlingdata opened this issue Sep 12, 2023 · 1 comment · Fixed by #3365

Comments

@erikdarlingdata
Copy link
Contributor

Is your feature request related to a problem? Please describe.
I recently ran into a situation where blocking and deadlocking was happening with background processes. It was helpful for me to add a check to HumanEventsBlockViewer to summarize how often it was happening, so I'd like to get it in here too.

Describe the solution you'd like
Add a check alongside the one for deadlocks with sleeping queries to look for deadlocks with background tasks.

Describe alternatives you've considered
Living in utter darkness for 40 years

Are you ready to build the code for the feature?
Yeah, I'll have it ready shortly.

@erikdarlingdata erikdarlingdata self-assigned this Sep 12, 2023
erikdarlingdata added a commit to erikdarlingdata/SQL-Server-First-Responder-Kit that referenced this issue Sep 28, 2023
Something really weird is going on with my repo. I'm going to create a pull request for BrentOzarULTD#3347 and BrentOzarULTD#3329 to see what happens.
@BrentOzar BrentOzar added this to the 2023-10 Release milestone Oct 10, 2023
@BrentOzar
Copy link
Member

Thanks for the pull request! Makes sense, other than the weird spaces and line return stuff. Merging into the dev branch, will be in the next release with credit to you in the release notes.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants