Most of the time on particularly intense / long queries, I’m not able to close the connection to Sybase straight away.
The alternate product we occasionally have to use is DBArtisan, which closes the connection straight away.
I’ve definitely found this to be the case for ASE 12.5.4 and haven’t noticed any different behaviour on ASE 15.
Is this due to DBArtisan forcing the connection closed / not confirming if it was? It’s one of the ‘features’ I miss about DBArtisan.
This can particularly be annoying when you’ve mistyped / misremembered a query, and it’s going to cause a large amount of data to come back.