IF @@trancount > 0 COMMIT TRANSACTION causing blocking
0
votes
1
answer
1372
views
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. The implicit transactions are causing a lot of blocking. When I checked I always find that the head of the blocking is:
set implicit_transactions off IF @@TRANCOUNT > 0 COMMIT TRAN
What can I perform from the database side to avoid this problem?
This is the query I got from

sp_whoisactive
or sp_BlitzFirst
moreover implicit transaction warning. I am not able to capture the whole transaction.
Asked by sebeid
(1415 rep)
Oct 16, 2020, 01:50 PM
Last activity: Jan 11, 2025, 01:15 PM
Last activity: Jan 11, 2025, 01:15 PM