always on ms-sql, open transactions
Baan: ERP LN 6.1 FP8 (Infor ERP 10.2)
DB: SQL Server 2016
In our always on environmet (sqlserver) we experience the fact that the statement dbcc opentran('name of the database') reports active transactions which can be days old.
The problem is that due to this the transaction log can't be truncated/shrinked.
With other statements we can always pinpoint the bshell that's causing it, after closing it is solved.
The transaction reported always is exactly started on the hour (e.g. 9:00:00:xxxAM) which is weird.
I have never seen this in other sql server environments.
We have been discussing it with infor but they don't think it's a bug in their driver. Our sql server is patched up to the latest software. We have reported this to microsoft, haven't received an answer yet.
Anyone else seen this?