Labcoat
Enthusiast
Enthusiast

Too big for the SQL Bundled 2K8 Express Database?

Jump to solution

I'm plodding through the vCenter Server 5.1 Upgrade Guide, the entire time assuming I do not need to worry about installing a full SQL DB for 5.1, and I come across this on Page 51:

> Microsoft SQL Server 2008 R2 Express: Bundled database that you can use for small deployments of up to 5 hosts and 50 virtual machines.

I have 3 hosts and 36 VMs.  Of these 36 VMs, about 25 are critical.  We will be growing, but we should be good for another year or more.

Question1: should I bother with the time, licensing and so forth to create a full SQL DB for vCenter 5.1 upgrade?

Question2: does SQL 2K8 R2 Express come with the .iso for the vCenter upgrade, and just install/upgrade it first?

ty

-lc

0 Kudos
1 Solution

Accepted Solutions
marcelo_soares
Champion
Champion

Reply 1: You can go with the Express one for your deployment. In fact, the limitation is a soft one, and only impacts on the DB size stored by vCenter (Express R2 now have a 10GB limit DB size) and performance. You CAN have more than 50 VMs / 5 ESX, but if you have a problem with your vCenter service (i.e. vCenter not starting, slow performance when accessing the inventory, etc), VMware will not support you in this case. VMs will not be affected by this.

Reply 2: Yes, SQL Express come bundled on the VC installation. It installs with vCenter (you can choose this during the installation process).

Marcelo Soares

View solution in original post

0 Kudos
1 Reply
marcelo_soares
Champion
Champion

Reply 1: You can go with the Express one for your deployment. In fact, the limitation is a soft one, and only impacts on the DB size stored by vCenter (Express R2 now have a 10GB limit DB size) and performance. You CAN have more than 50 VMs / 5 ESX, but if you have a problem with your vCenter service (i.e. vCenter not starting, slow performance when accessing the inventory, etc), VMware will not support you in this case. VMs will not be affected by this.

Reply 2: Yes, SQL Express come bundled on the VC installation. It installs with vCenter (you can choose this during the installation process).

Marcelo Soares

View solution in original post

0 Kudos