Extreme page splits… and more?

Oopps! Upgrade your browser pretty please. Oopps! Upgrade your browser pretty please.

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?