Long locks on database objects
Baan: Infor ERP 10.4
OS: Windows 2016
we have another problem with baan on SQL Server 2017. Baan is not closing transactions and it is holding locks for hours, sometimes even days.. actually forever, as long as session is alive. Every single session on the server has one open transaction.. at all times.
Is there any option we could set to commit/rollback transactions on the database? Those transactions should be fast and release locks for other to use the database.
Version of RDBMS:
Microsoft SQL Server 2017 (RTM-CU14) (KB4484710) - 14.0.3076.1 (X64) Mar 12 2019 19:29:19 Copyright (C) 2017 Microsoft Corporation Standard Edition (64-bit) on Windows Server 2016 Datacenter 10.0 <X64> (Build 14393: ) (Hypervisor)