1 Reply Latest reply on Dec 14, 2012 9:10 AM by dsbalcau

    Purging Event Monitor Data

    cdekort

      Hi All,

       

      I've taken over SM from a previous employee (that left several months ago) and I'm doing some general tidiying up of the reports, arrays etc.

      When trying to load the Event Monitor it takes ages - I've left it overnight and still doesn't load & I can see it hammering the disk through perfmon.

       

      I'm about to do a backup and run the DB Maintenance file, but was wondering if anyone has a script that can purge the data from that particular table?

       

      Also is it advisable to run the maintenance of the DB before doing an upgrade & how often should the maintenance script be run?

       

      Thanks,

      Chris