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 - Performance improvement when using system_health event session #3232

Closed
erikdarlingdata opened this issue Feb 22, 2023 · 2 comments

Comments

@erikdarlingdata
Copy link
Contributor

Is your feature request related to a problem? Please describe.
In the sys.fn_xe_file_target_read_file function lives a column called object_name that can be used to filter to just the rows returned for the deadlock xml. Using this is usually much faster.

Describe the solution you'd like
I would like to add one weird line of code to make this thing go a lot faster.

Describe alternatives you've considered
Being happy.

Are you ready to build the code for the feature?
It is done.

@BrentOzar
Copy link
Member

Thanks for the pull request! Looks good, merging into the dev branch, will be credited to "Red Wine at 5AM" in the release notes.

@erikdarlingdata
Copy link
Contributor Author

One additional note for future reference: There is also a timestamp_utc column available in SQL Server 2017+, but it is rather buggy. I am skipping going down the dynamic SQL route here for now.

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

No branches or pull requests

2 participants