Truncate vpx_event table in vCenter database

Hi,

I recently had a problem at a client's site with vSphere vCenter 5.1, where the client had SQL Express which is limited to 10GB database.

This should be more than working, but the client has exploded the 10GB, where the calculator was expecting less than 3GB.

The Events and Tasks tables were faulty, and to clean up in emergency, we used the script on the blog below to clean the faulty tables.

The identify them we used the following script : http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1028356

• Manually run this SQL query against the vCenter Server database:
  
  select object_name(id) [Table Name], 
  [Table Size] = convert (varchar, dpages * 8 / 1024) + 'MB' 
  from sysindexes where indid in (0,1) 
  order by dpages desc
  
  This query lists all tables in the vCenter Server database by table size in MB.

--> Please see the rest on the blog : http://www.vfrank.org/2011/04/28/truncate-vpx_event-table-in-vcenter-database/