VMware Cloud Community
jaturley
Contributor
Contributor
‎06-14-2011 07:27 AM

Huge vcenter 4.1 database

I am running vcenter 4.1 with the database on MS SQL Server 2008.  I have truncated the history tables but the data base is still huge 351 Gig.  I only have 5 ESX hosts and around 25 virtual machines.  Any ideas?

0 Kudos
3 Replies
vmroyale
Immortal
Immortal
‎06-14-2011 07:28 AM

Hello.

Check out kb 1025914.

Good Luck!

Brian Atkinson | vExpert | VMTN Moderator | Author of "VCP5-DCV VMware Certified Professional-Data Center Virtualization on vSphere 5.5 Study Guide: VCP-550" | @vmroyale | http://vmroyale.com
0 Kudos
Troy_Clavell
Immortal
Immortal
‎06-14-2011 07:29 AM

Yes, the first thing I would do is the set your recovery model to simple, then purge/re-index.  Also, check your transaction logs

http://www.vmware.com/resources/techresources/1025

http://kb.vmware.com/kb/1028356

0 Kudos
AndreTheGiant
Immortal
Immortal
‎06-14-2011 08:25 AM

Also check stat collection in vCenter to see how they are set.

With level 3 or more you can have a lot of data.

Andre

Andrew | http://about.me/amauro | http://vinfrastructure.it/ | @Andrea_Mauro
0 Kudos