Manually purge the database using a stored procedure within SQL Management Studio
When attempting to purge a large amount of events from the database via the Active Administrator Server Management “Purge Events” function, the purge can take a long time, appear to be stuck, or give a “System out of memory” error.
As an alternative, the dbo.PurgeAlertLogs stored procedure within SQL Management can be used.
IMPORTANT: Always make a backup of the database before purging data!
Note: Using the stored procedure will delete all events prior to a certain date. The purge option within the Active Administrator Server Management Console allows granular purging by selected events, as shown in the screen shot below.
To use the Stored Procedure for purging events, open the SQL Management Studio and expand the Active Administrator database. The default database name is ActiveAdministrator. Select Programmability | Stored Procedures:
Right click the dbo.PurgeAlertLogs stored procedure and select “Execute Stored Procedure”.
Enter a date in the “Value” field. In the example below, any events that occurred prior to 11/01/2011 will be purged. Click OK.
Verify that the Active Administrator database is selected and then “Execute” the query: