Enhance error when connection is broken by a SQL Server issue during import

microsoft / SqlNexus

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

Enhance error when connection is broken by a SQL Server issue during import #143

Open PiJoCoder opened 2 years ago

PiJoCoder commented 2 years ago

Enhancement: When SQL Nexus runs and hits an AV on the SQL Server side, the connection may be broken and SQL Nexus will get this type of error.

ExecuteReader requires an open and available connection. The connection's state is closed

Could there be possible ways to improve the error (bubble some more information from SQL Server up) so that it is clear to the user what happened .

gambit9009 commented 2 years ago

When we start looking into this, consider also timeout exceptions. Some SQL Nexus might run a long time and then timeout, probably during the end crunch stages. The data is in the tables. Is there a good/esay way to restart the analysis after import? Is there a better way to catch timeouts, and maybe with a switch or Settings, retry the query that got the timeout? Either by swtich or Settings or with an error messagebox, offer to extend the execution timeout and retry instead of just dying?