Start Free Trial

asked on 2/29/2016

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

VMware Virtualization Microsoft SQL Server 2008

Last Comment

3/5/2016

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

2/29/2016

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

2/29/2016

Blurred text

THIS SOLUTION IS 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

SOLUTION

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

2/29/2016

Blurred text

THIS SOLUTION IS 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

2/29/2016

ASKER

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

3/5/2016

ASKER

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

Microsoft SQL Server 2008

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the Always On technologies and support for unstructured data types.

50K

Questions

--

Followers

--

Top Experts

Get a personalized solution from industry experts

Ask the experts

"Invaluable tool for our organization"
Josh Regalski
"This is the best money I have ever spent."
@rwheeler23
"Your help has saved me hundreds of hours of internet surfing."
@fblack61
"Just a dang good service!"
@golferski
"Worth every penny."
Steve Hougom
"It’s been a life saver."
Maria Halt
"Best support site I’ve seen!"
Bob Schneider
"I would be lost without them."
@fblack61
"Saved my job multiple times."
Walt Forbes
"I love this site."
Maria Duwe
"Friendly respectful help."
Andrew Kowtalo
"Such top-notch experts."
@magento
"The best money I have ever spent."
@rwheeler23
"Beyond any comprehensible value"
George Morris
"Invaluable tool for our organization"
Josh Regalski
"This is the best money I have ever spent."
@rwheeler23

Read over 600 more reviews

TRUSTED BY