Row versioning var något som kom i och med SQL Server 2005. Kort sagt innebär…
Recently, while evaluating the performance of a production system, I was alarmed by the “SQLServer: Access Methods Page Splits/ sec” occuring in the system. It turned out that if you have the “Activity Monitor” on, then there is a SQL Statement running which executes “EXEC #am_get_querystats”, with CPU about 967, Reads about 50000, Writes 646 and it refers to the tempdb. So, what other counters is the Activity Monitor affecting?