I am preparing a migration from VMware 3.5 to vSphere 4.0. Three new ESX 4 host servers will be installed into production. The three 3.5 host servers currently being used will be upgraded to v4 and then moved to our off campus DR site. We will end up with 3 host servers at each location. The production location current has 18 VMs to be migrated to v4. We are projecting 5 more servers will be p2v and 5 new guests will be added to the environment. Our projection is that in a year we will still have 3 hosts servers and be up to about 30 VM guests.
We will be using SRM to manage the VM failover between the production location and the DR location. In a DR situation it is planned for all guests servers to be on line. Otherwise the guest servers are in a standby mode.
We are having a “discussion” as to the location of the vCenter, Update Manager and SRM databases should be located. The VM installation manual states that SGL 2005 Express can be used for a small VM environment. 5 hosts and 50 VM guests is considered to be a small VM environment. We would like to use sql express to hosts the databases locally on each vCenter server. Both the production and the DR site will have its on vCenter server.
The var is stating this is a bad idea. They recommend that sql express should not be used in production due to its limitations. If the environment grows the database would have to be moved to a sql server.
Is it a bad practice to use sql 200 express in a production environment?