HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

sp_whoisactive - Do stats include activity for snapshot versioning?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
sp_whoisactiveincludestatssnapshotforactivityversioning

Problem

On a system that has read committed snapshot isolation enabled, do the reads, writes, CPU, etc. stats returned by sp_whoisactive include the activity associated with maintaining versions in tempdb?

Solution

I don't believe so, since none of the common DMVs used to track version store usage are present in the proc code.

Context

StackExchange Database Administrators Q#218756, answer score: 3

Revisions (0)

No revisions yet.