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

Warn about overhead of certain scenarios #117

Open
gambit9009 opened this issue Jul 8, 2021 · 1 comment
Open

Warn about overhead of certain scenarios #117

gambit9009 opened this issue Jul 8, 2021 · 1 comment
Labels
enhancement wave 3 consider this issue for next wave of fixes

Comments

@gambit9009
Copy link
Contributor

Moved from other DiagManager Issues

Some of our scenarios like, "Detailed Performance", capture enough data points to possibly cause performance overhead. (begin & complete, statement level, transactions, query plans, etc). Adding some other events manually could cause overhead on an system already having perf issues.
couple of examples...
...."wait_info" event(Scheduling))
...events that could be redundant(like adding all the showplan's)
...large number of batches/sec (and I know "large" depends on perspective)
....anything on a busy system that ends up collecting large 100's of GBs or TB worth of data

We could update the tool to be more clear on the POSSIBLE overhead some of these scenarios can place on a system or combinations of scenarios.

And/or show a count of the number of Events that will be collected based on the current selected events. Maybe on XEvent, Trace and Profiler tabs.

@PiJoCoder PiJoCoder added the wave 3 consider this issue for next wave of fixes label Apr 15, 2022
@PiJoCoder
Copy link
Contributor

We can add some text to the email out for customers. Plus add a notification in the pssdiag.ps1 maybe.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement wave 3 consider this issue for next wave of fixes
Projects
None yet
Development

No branches or pull requests

2 participants