martedì 26 luglio 2011

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