VMFAQ.com - FAQing about virtualization since 2008
Search:     Advanced search
Browse by category:
Contact Us

My VirtualCenter database is huge and slow, can I purge it?

Add comment
Views: 4518
Votes: 1
Comments: 0
Posted: 22 Sep, 2008
by: Huhtinen H.
Updated: 17 Oct, 2008
by: Huhtinen H.

VirtuaCenter database grows overtime, and may become slow. Databases with sizes over dozens of gigabytes are not unheard of. If the size becomes a problem, the database can be purged. What fills it mostly is alerts and events. Performance data is purged automatically.

To purge the database, see VMware KB article with purge scripts attached at http://kb.vmware.com/kb/1000125.  (Thanks slowe for pointing this out )

Also, check your statistics collection level settings, found in the Administration menu of VI Client (see pic below). Keep database recovery model at bulk or simple while upgrading VC, and if using full recovery model, backup and truncate logs regurlarly.

 

Others in this Category
document I'm trying to install ESX4, but it stalls at 26% then slowly goes up to 29% and then nothing happens
document Recommendations for template virtual machines
document Can I grow an existing virtual disk (.vmdk file)?
document Insufficient capacity on each physical CPU
document Recommended performance tuning options for Linux guests
document Active Directory and VMware snapshots
document Running IBM UpdateXpress System Pack from the Service Console of ESX4
document What does ESX stand for?
document Where can I find a vSphere Client for Linux / Mac OSX?
document Call "HostDatastoreSystem.CreateNasDatastore" for object "ha-datastoresystem" on ESX "esxhost" failed.
» More articles



RSS