asked on

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

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

Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)

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 ?

ASKER CERTIFIED SOLUTION

badabing1

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

SOLUTION

Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer