search

amachanic / sp_whoisactive

sp_whoisactive
GNU General Public License v3.0
1.13k stars 281 forks source link

active_transaction_count > than reported on sys.dm_tran_active_transactions #116

Closed ptmarco closed 6 months ago

ptmarco commented 6 months ago

Environment: SQL Server 2016 13.0.7029.3 sp_WhoIsActive returns open_tran_count = 2 for spid 80 but in sys.dm_tran_active_transactions session 80 has only 1 active transaction, in transaction state 2.

example

ptmarco commented 6 months ago

Nevermind, it's a Microsoft thing, the old sysprocesses view is the source of the problem. Sorry for the issue. I will close it.