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 there Greg!  Good to hear from you again.

Without going into the gory details around how SQL Sentry collects statements and matches them up, a "-1=RequestCompleted" event occurs when we see a SQL statement start, but we never see the "End" event for whatever reason.  This is sometimes due to a long(er) running query or a high amount of data moving through the XE ring buffer.    The best way to think about it is a SQL statement that we definitely saw start, never saw it explicitly end, and artificially marked it as being closed/finished.

Hopefully this helps explain it...let us know if you have more questions about it!

-BT