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
If a query in PerfStatsAnalysis.sql fails, it will catch and keep running without warning the user #120
Related to #119
CSql.cs ExecuteBatches that will break apart PerfStatsAnalysis.sql at the "GO's" has a SQLException catch for the tsql that logs it in SQLNexus log but doesn't warn the user directly that some data was not imported (or that tables, views, sp's, etc. might not have been created). We are re-throwing for a general Exception, just not the SQLException.
Worst case, add something to GUI like "Errors occurred during import. See SQLNexus.log". We could add that in the label we have for each step where we say "Done".
Related to #119 CSql.cs ExecuteBatches that will break apart PerfStatsAnalysis.sql at the "GO's" has a SQLException catch for the tsql that logs it in SQLNexus log but doesn't warn the user directly that some data was not imported (or that tables, views, sp's, etc. might not have been created). We are re-throwing for a general Exception, just not the SQLException.
Worst case, add something to GUI like "Errors occurred during import. See SQLNexus.log". We could add that in the label we have for each step where we say "Done".