Purging old data from the database used by vCenter Server 4.x

• If the DB has reached a 4GB limit in SQL express, if the DB is corrupted, or if vCenter is unavailable for any reason, purge the event and event_arg tables either by manually enabling the DB retention policy in the DB using SQL Studio, or by running the stored procedure to purge the data from these tables
• • To enable the database retention policy for the events and tasks, Open table dbo.VPX_PARAMETER:
  • • Modify event.maxAge to a value in days.
    • Modify event.maxAgeEnabled to value of true.
    • Modify task.maxAge to a value in days.
    • Modify task.maxAgeEnabled to a value of true
  • Run the built in stored procedure: from the VCDB > Programmability > Stored Procedures > Right-Click dbo.cleanup_events_tasks_proc and click execute. This will purge the data from tables:vpx_event, vpx_event_arg and vpx_task based on the date specified for maxAge
    
    
    
    
    Fonte : VMware KB