Planning to upgrade from Windows vCenter 6.5 to VCSA 6.7, and need to migrate View Composer currently co-installed on this server to a new Windows server. Is SQL Express powerful enough to handle roughly 150 virtual desktops or best to pay the $ for SQL Standard?
Thanks in advance.
For that size and you absolutely don't anticipate any growth, I'd say it's fine, but not preferred.
For any production environment I'd use a server dedicated to SQL, instead of co-mingling the two components.
For that size and you absolutely don't anticipate any growth, I'd say it's fine, but not preferred.
For any production environment I'd use a server dedicated to SQL, instead of co-mingling the two components.
thanks mchadwick19,
Would you say be in terms of size that SQL Standard is needed? Also, are you recommending that Composer on 1 server and SQL on a separate server?
Thanks again!
There used to be a recommendation based on size of the environment, but I can't seem to find it anymore. I remember prior versions recommending no more than 100 desktops on a SQL express instance.
For anything larger than a couple hundred VM's I'd recommend a separate SQL server and standard. For your size you should be fine to co-install SQL with composer.
A full install of SQL makes it much easier to manage (the DB) and you can use it for other view components like the events DB and AppVolumes (down the road).
