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

PerfStatsAnalysis.sql doing some SELECTs that really go no where #119

Open
gambit9009 opened this issue May 20, 2021 · 0 comments
Open

PerfStatsAnalysis.sql doing some SELECTs that really go no where #119

gambit9009 opened this issue May 20, 2021 · 0 comments

Comments

@gambit9009
Copy link
Contributor

Example:
RAISERROR ('==== Top 10 Blocking Resources ====', 0, 1) WITH NOWAIT;
...is a header of one of the SELECTs or SPs that run and output data direct into the SQLNexus app log. Some of these are complex CTE's with recursion that could actually make SQL Nexus longer to run...basically we are running queries and getting results sets that are almost certainly never looked at.

Some of these queries are probably pretty helpful. Consider adding these SELECTs and SP's to a report if they are not already being used. They just shouldn't be running as part of PerfStatsAnalysis.sql

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

No branches or pull requests

1 participant