SQL Nexus is a tool that helps you identify the root cause of SQL Server performance issues. It loads and analyzes performance data collected by SQL LogScout, SQLDiag or PSSDiag. It can dramatically reduce the amount of time you spend manually analyzing data.
MIT License
356
stars
101
forks
source link
PerfStatsAnalysis.sql doing some SELECTs that really go no where #119
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
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