VMware Horizon Community
EecITSupport
Contributor
Contributor
Jump to solution

SQL Express sufficient with View Composer 7.10?

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. 

1 Solution

Accepted Solutions
mchadwick19
Hot Shot
Hot Shot
Jump to solution

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.

VDI Engineer VCP-DCV, VCP7-DTM, VCAP7-DTM Design

View solution in original post

3 Replies
mchadwick19
Hot Shot
Hot Shot
Jump to solution

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.

VDI Engineer VCP-DCV, VCP7-DTM, VCAP7-DTM Design
EecITSupport
Contributor
Contributor
Jump to solution

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!

Reply
0 Kudos
mchadwick19
Hot Shot
Hot Shot
Jump to solution

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).

VDI Engineer VCP-DCV, VCP7-DTM, VCAP7-DTM Design