In the output of sp_WhoIsActive
, are columns such as reads, writes, CPU, and wait_info cumulative for the session, or just cumulative for the batch? We have a query that is blocking a lot and showing millions of reads, but when I run the eight queries in the batch from SSMS, the reads are in the single digits, so I'm trying to understand whether something different is occurring with the way the application is running it to cause it to read so much more.
Or could it be something different? I notice that the session has 2 open transactions. Could those stats represent all of the transactions that session currently has active?