Is @get_transaction_info = 1 accurate?

amachanic / sp_whoisactive

sp_whoisactive

GNU General Public License v3.0

1.18k stars 290 forks source link

Is @get_transaction_info = 1 accurate? #112

Closed jcggaurino closed 3 months ago

jcggaurino commented 10 months ago

Hi @amachanic, Our organization was trying to utilize this option to get transaction log information of a process/query but when testing, tran_log_writes shows mostly "0 kB" for a database that has been using most of the transaction log already. Is there an open issue with this parameter not capturing the correct data?

image-2023-12-20-16-16-03-656 image-2023-12-20-16-16-14-761 image-2023-12-20-16-16-26-251

erikdarlingdata commented 3 months ago

@jcggaurino yes, it is accurate. You’ve blanked out the query text so I can’t see if any modifications are executing, but when I test locally, it shows non-zero numbers where it should.

jcggaurino commented 1 month ago

@erikdarlingdata It took a while for your update so I almost forgot this. Yup I've intentionally removed the sql text, will try to grab another occurrence of this and share here including the sql text.