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?
Check out kb 1025914.
Yes, the first thing I would do is the set your recovery model to simple, then purge/re-index. Also, check your transaction logs
Also check stat collection in vCenter to see how they are set.
With level 3 or more you can have a lot of data.