Virtual Center Server Service Stops -SQL database reached its limit.

badabing1
badabing1 used Ask the Experts™
on
Hi.

I’m struggling to reduce the size of my Vcenter 5.0.0,455964  database and because of its size limit of 10GB (express version) the vCenter service stops. I’ve run the below following both articles to letter and it seems to work for a day or two and then it stops again. How can i reduce the size of Vcenter currently stands at 10,485,184.

We have 3 hosts attached to SAN and about 30 VM - surely this can’t be right to be this big in size?



https://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1025914

http://www.petenetlive.com/KB/Article/0000479

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Andrew Hancock (VMware vExpert / EE Fellow)VMware and Virtualization Consultant
Fellow 2018
Expert of the Year 2017

Commented:
VMware vSphere 5.0 has got exceptionally noisy, and SQL Express, is not really recommended anymore, hence VMware's decision to use internal databases non-SQL with vCenter Server for Windows and Appliance in the future (version 6.0), and vCenter Server for Windows, will in the future be discontinued, in favour of the Appliance.

e,g. it's not uncommon with vSphere 5.x, for the 10GB database to exceed 10GB after a few months, depending upon, number of hosts and VMs, but even if using the basic Essentials License of 3 Hosts, your database will exceed 10GB, with 3-4 months.

Okay, back to your issue....

How may hosts and VMs do you have?

I suspect the issue is the Tables - Events and Tasks?

are you good with SQL, and can see the size of these tables ?
i am re-running the built in SQL cleanup procedure and it seems to be shrinking it, not sure why it didnt do it the first time.

Will update soon.
Andrew Hancock (VMware vExpert / EE Fellow)VMware and Virtualization Consultant
Fellow 2018
Expert of the Year 2017
Commented:
I have some SQL procedures, which will show the size of the Tables in the vCenter database, and also some procedures which purge all Events and Tasks, which are not really required, which can reduce the size, further, let me know, if you want me to post them.

Author

Commented:
event cleanup procedure did the trick, not sure why it didnt do it the first time.

Author

Commented:
Thanks but i have managed to shrink it by running the event cleanup procedure.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial