We have a Java application / hibernate connecting to SQL Server. It looks like implicit transaction is on by default. I am not sure if this is from hibernate or JDBC Driver . However this implicit transactions are causing alot of blocking. when I checked I always find that the head of the blocking is
set implicit_transactions off IF @@TRANCOUNT > 0 COMMIT TRAN
My question is what can I perform from the database side to avoid this problem?