Databases in VMware vCenter 6.0

I upgraded to vPostgres database in vCenter 6.0 from MS SQL Express of vCenter 5.5. (Have 6 hosts, and about 100 VMs.) vCenter is working fine and I even backed up vPostgres database.
Two questions:
1. Why is MS SQL Express database still active? Its database files have current time and date. How do I get rid of it?
2. For Update Manager, vPostgres is no help. Do I need to install a full SQL database?

Thanks.

Ajay
LVL 3
AkulshAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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 MVE^2)VMware and Virtualization ConsultantCommented:
1. What is using it? Stop the SQL Service....could just be chatter...SQL DB are live all the time, whilst the service is running. Uninstall SQL Express.

2. SQL Express will do....which comes with Update Manager....you do not need SQL FULL edition.

see my EE Articles

HOW TO: Install and Configure VMware vSphere Update Manager (VUM) 6.0

HOW TO: Upgrade VMware ESXi 5.1 and ESXi 5.5 to ESXi 6.0 with VMware Update Manager (VUM)

HOW TO: Update (Patch) VMware ESXi 6.0.0 GA to ESXi 6.0.0b with VMware Update Manager (VUM)

eventually, all will be on  vPostgres database!
AkulshAuthor Commented:
2. Yes VUM has built-in SQL express but right under the checkbox it says -- for up to 5 hosts and 50 VMs.

I don't see how that is good enough for me.

Thanks.
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Your environment is still considered small.

You can always monitor the SQL Express database does not grow beyond 10GB, it certainly would if this was vCenter Server 6.0, which is the reason for dropping SQL Express, because Essentials with three hosts and VMs, were Tasks and Events tables would grow very large due to noise.

(and if you look at the documentation it's still in Beta! with Draft comments!)

If it does, then upgrade to SQL Full version.

Database size depends on a few factors

how much scanning you do of hosts for patches, upgrades, VMs for VMware Tools Upgrades and virtual hardware upgrades.

if you do, 1 scan a month for tools, and hardware version, 2 scans a month for patches, 1 scan a month for upgrades, your SQL size will be small.
The 7 Worst Nightmares of a Sysadmin

Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.

AkulshAuthor Commented:
Andrew,

You are quite likely correct that 6 hosts and 100 VMs can be handled by SQL Express for VUM. But I may install full SQL version because that leave rooms for expansion. Unlike for vCenter itself where SQL database has to be customized with all kind of tables, here default SQL install should be good enough for VUM. Right? Thanks.
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Yes, if you have the license, and it's not going to cost you.

Database usage is very light....

check Chapter 3 for details on SQL , default SQL install is okay.

http://pubs.vmware.com/vsphere-60/topic/com.vmware.ICbase/PDF/vsphere-update-manager-60-install-administration-guide.pdf

remember the DSN is 32-bit, because Update Manager is only a 32bit app!

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
AkulshAuthor Commented:
Thanks. (Yes I know the drill about 32 bit DSN since I added VUM instance to another VMware infrastructure which was using full SQL.)
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
VMware

From novice to tech pro — start learning today.