I am in the planning process of building a new vCenter 5 server. Currently, as a SMB, my host requirements are within range of using the SQL Express install, but my VM count has grown into the lower triple digits. In my current vCenter I have been starting to experience some slowdown while loading the inventory so I am curious if my choice of SQL Express for the vCenter 4.1 install, and the VM inventory count, is causing this. What do you think?
If I do choose to install SQL 2008 R2, vs Express, would I expect to see a more responsive client when logging into vCenter and loading the inventory? As far as growth I don't anticipate going to double digit hosts or greater than 300 VMs. Could just selecting the next radio button up for the SQL Express install, even though I won't hit that amount of hosts/VMs, give better performance?