I also noticed this suddenly appearing in SQL Server Profiler (SQL 2008R2).

EXEC #am_generate_waitstats; seems to execute if the Activity Monitor is open in SSMS 2008R2