sp_sqlagent_get_perf_counters: what are they and how to remove them?
Within your SQL Server environment many times you might have observed sp_sqlagent_get_perf_counters running within the Profiler trace, sometimes they may result in high CPU conditions. They are demo alerts to test whether the alerts are working within your environment.
You can safely delete or drop them if you are not using the DEMO based alerts, to drop them :
Open Enterprise Manager and expand the Managemen --> SQL Server Agent folder and click on Alerts.You should see 9 alerts whose names all start with Demo. Select them all and Delete.