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


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?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Andrew Hancock (VMware vExpert / EE Fellow)VMware and Virtualization ConsultantCommented:
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 ?
badabing1Author Commented:
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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Andrew Hancock (VMware vExpert / EE Fellow)VMware and Virtualization ConsultantCommented:
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.
badabing1Author Commented:
event cleanup procedure did the trick, not sure why it didnt do it the first time.
badabing1Author Commented:
Thanks but i have managed to shrink it by running the event cleanup procedure.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.