In SentryOne (latest version) - We know 'Top SQL' - Error Code of #1 is an 'error' and #2 is an 'Abort' but what does the #-1 represent? thank you as always, Greg

Hey,

This blog from Patrick might be able to help:
https://www.sentryone.com/blog/sentryone-top-sql-tips-and-tricks 

"If a query in Completed Queries is highlighted in red, it means the query failed. Something to examine in this case is the Error column. In this column, an error will usually display as 1=Error or 2=Abort. If you see Error, then it's likely due to an internal SQL Server error or deadlock. As for Abort, this is usually tied to timeouts or manually getting killed. So, whenever you see Abort, the next thing you should check is duration, to see if the query got killed right at an obvious timeout threshold such as 30 seconds."

Hey,

This blog from Patrick might be able to help:
https://www.sentryone.com/blog/sentryone-top-sql-tips-and-tricks 

"If a query in Completed Queries is highlighted in red, it means the query failed. Something to examine in this case is the Error column. In this column, an error will usually display as 1=Error or 2=Abort. If you see Error, then it's likely due to an internal SQL Server error or deadlock. As for Abort, this is usually tied to timeouts or manually getting killed. So, whenever you see Abort, the next thing you should check is duration, to see if the query got killed right at an obvious timeout threshold such as 30 seconds."