Sample Header Ad - 728x90

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? enter image description here 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