Demo alerts

  • With the installation of SQL 2000 came 9 Demo Alerts(Management - SQL Server agent - Alerts).

    Names like: "Demo: sev 19 errors" and "Demo: full msdb log"

    They are all enabled.

    What I have also noticed is that every 20 sec there is and execution of msdb.dbo.sp_sqlagent_get_perf_counters and from what i understand this SP and the demo alerts in SQL agent go hand in hand.

    The execution of msdb.dbo.sp_sqlagent_get_perf_counters takes up a lot of CPU and I was wondering if I can safely delete these demos (or at the very least disabled them)?

    Will this stop the process executing the SP every 20 sec?

    Will it cause problems it i do delete/disabled them?

  • You can delete or disabled them and the perf counter process will/should stop.

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply