Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have SQL Server express installed on vCenter, so the maximum size of the database can be only 4GB. I don't know why, but from some moment the size of the db started to grow exponentially, so I have to delete the data which is older than 40days with the script provided on the vmware site (VCDB shrink sql or so ..)

The question is, is there any verbose/debug flag, which I accidentally enabled time ago, so the DB is filling more rapidly? The VMs count did not change in the past and I did not change anything substantial in the infrastructure.

Or maybe everything is behaving alright and the SQL server should be upgraded ? (40 VMs)

ESXi 4.1 cluster Essentials Plus Appliances installed vDR, vMA

share|improve this question

2 Answers 2

up vote 1 down vote accepted

As you've surmised, a higher logging level can create quite a large database.

Here's how you check/change your logging level on vCenter.

In the vClient: Administration Menu -> vCenter Settings -> Logging Options.

If offers you a range from None to Trivia (extremely verbose)

NB: VMware does offer a sizing calculator you can use to predict your systems log growth: http://www.vmware.com/support/pubs/vs_pages/vsp_pubs_esx40_vc40.html

share|improve this answer

I would check check what are the settings for Statistics in vCenter Settings.If they are changed from default, this could generate a lot of data. Eventually you will have to bite the bullet and buy the proper SQL , I believe Vmware recommendation is not to use express edition for site with more than 50 vms.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.