We help IT Professionals succeed at work.

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

272 Views
Last Modified: 2014-05-27
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
Comment
Watch Question

Paul SolovyovskySenior IT Advisor
CERTIFIED EXPERT
Top Expert 2008

Commented:
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)VMware and Virtualization Consultant
CERTIFIED EXPERT
Fellow
Expert of the Year 2017

Commented:
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)VMware and Virtualization Consultant
CERTIFIED EXPERT
Fellow
Expert of the Year 2017

Commented:
Or switch to VCenter Appliance which is better.
Andrew Hancock (VMware vExpert PRO / EE Fellow)VMware and Virtualization Consultant
CERTIFIED EXPERT
Fellow
Expert of the Year 2017

Commented:
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
VMware and Virtualization Consultant
CERTIFIED EXPERT
Fellow
Expert of the Year 2017
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.