Avatar of NAMEWITHELD12
NAMEWITHELD12
Flag for United States of America asked on

VMWARE vCenter DB is 9GB in size after a few months 15 hosts 500 VMs , is this normal?

I am sure that I can just make the performance statics less verbose , it there any other thing I can do to make the DB healthy and small?

thanks
Microsoft SQL Server 2008VMwareVirtualization

Avatar of undefined
Last Comment
Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)

8/22/2022 - Mon
Paul Solovyovsky

It depends on how long you keep the events for.  Take a look at retention under Administration Settings.  By default the check boxes are unchecked and we set it to 60 days.  You should also check what level of logging you're doing, Level 3 and 4 will give you more information but will take more space

Just make sure that you're running full blown SQL instance, SQL Express has a 10GB limit.   You should also setup maintenance plan for the DB and Logs.
Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)

What size is the event table?

SQL Express is too small for your environment upgrade to SQL full.
Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)

Or switch to VCenter Appliance which is better.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)

VMware support have stipulated that SQL Express is no longer suitable for large installations as far more tables and information is now written to the database.

1. Check table sizes with all your current issues and changes I would expect the events table to be massive this can be dropped and DB reduced.

2. Change and keep events for 7 to 14 days

3. Or upgrade to SQL Full OR

4. VCenter Appliance and Postgress Database now can handle larger environment s
ASKER CERTIFIED SOLUTION
Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.