VMware Communities: update manager and Virtual Center database setup = 1 database or the

Up to Discussions in VMware vCenter™ Server

This Question is Answered

3 Replies Last post: Dec 5, 2008 10:00 AM by vmroyale

update manager and Virtual Center database setup = 1 database or the same database??

Dec 5, 2008 9:35 AM

tlyczko 446 posts since
Oct 20, 2005

We have a small VMware environment -- 2-3 hosts, only 5-6 VMs for now, maybe up to 10-12 during 2009.

I've looked at the VUM and VC sizing spreadsheets and it appears that I can make VC and VUM work from SQL Express 2005 for the next 1-3 years, I have to allow for patch etc. storage and know that I may need to upgrade.

Do the VC and VUM installations create their own separate databases or are they combined into 1 database??

Or would I be better off buying 1 SQL Standard license with the 10 CALs instead?? (I know this would scale easily.)

Thank you, Tom

Tags: update_mgr, virtual_center, virtualcenter_database, database, virtualcenter

Reply Re: update manager and Virtual Center database setup = 1 database or the same database?? Dec 5, 2008 9:54 AM

Troy Clavell 4,799 posts since
Oct 12, 2007

you can share the DB instance will your VCMS instance. From my understanding all VUM does is create new tables within the existing DB. You might want to read through the adim guide, just in case I understand it wrong.

http://www.vmware.com/pdf/vi3_vum_10_admin_guide.pdf

hope this helps

Reply Re: update manager and Virtual Center database setup = 1 database or the same database?? Dec 5, 2008 9:57 AM

apatel1 82 posts since
Apr 25, 2006

If you are letting the VC and VUM installers create the databases on the SQL 2005 Express instance (named SQLEXP_VIM), it will create separate databases for each (VIM_VCDB for vCenter, and VIM_UMDB for Update Manager). It is possible to have both of them use the same database, though you'd have to specify the database and ODBC settings to the installer.

Hope that helps! Please help me out by marking my response as "helpful" or "correct" if you feel that it was useful!

-Amit

Reply Re: update manager and Virtual Center database setup = 1 database or the same database?? Dec 5, 2008 10:00 AM

vmroyale 1,253 posts since
Jun 15, 2007

Hello.

The install guide says that SQL Express is intended for less than 5 hosts and/or 50 VMs. If you don't plan on growing any more than you mentioned, I would leave it as is.

You can use either the same database that you use for VirtualCenter, or you can use another database for VUM.

Actions

View as PDF

Up to Discussions in VMware vCenter™ Server