topic Using SQL Express for Horizon 7.4, no composer in Horizon Desktops and Apps

Using SQL Express for Horizon 7.4, no composer

DaveMitchell201 — Fri, 06 Apr 2018 10:00:49 GMT

After a bit of advice from the collective please. We are looking a deploying a new Horizon View environment. We will only been using Horizon standard with no Composer server. Do you think it would be viable to use SQL express rather than a standard edition? As I understand it it will only be used for events so not that critical. what do people think?

Thanks

Re: Using SQL Express for Horizon 7.4, no composer

andiwe79 — Fri, 06 Apr 2018 13:04:19 GMT

What exactly would be your concerns about using sql express?

VMware Product Interoperability Matrices

I usually don't care about loosing the event database. Most of my customers don't do either.

So even if it grows unexpectedly just drop the db. Mostly using it for troubleshooting purpose.

So it depends on how long you want to retain the eventdb data.

Same with performance, if you need some reporting to be faster you could switch over to sql standard.

If you need the eventdb for such things as accounting over a long period sql express could be insufficient.

Just my opinion

Best regards

Andreas

Re: Using SQL Express for Horizon 7.4, no composer

DaveMitchell201 — Fri, 06 Apr 2018 15:13:43 GMT

Thanks Andreas. it's just that most people say not to use express for production, but if it's just for events then it's not critical. What about where to put the database? I don't really want to have an extra windows server just for hosting the database, what about putting it on the connection broker itself, has anyone done that and is it supported?

Re: Using SQL Express for Horizon 7.4, no composer

andiwe79 — Fri, 06 Apr 2018 16:39:35 GMT

No, installing SQL Server on the Connection Broker is not supported.

It may work but no one can guarantee.

Re: Using SQL Express for Horizon 7.4, no composer

surajr04 — Sat, 07 Apr 2018 00:27:54 GMT

Composer and Database server in one singe machine will work, however as andiwe79 mentioned, it is not recommended to have any other application running on Connection server.

As per VMware View documentation:

"The View Connection Server software cannot coexist on the same virtual or physical machine with any other View Manager software component, including a replica server, security server, View Composer, View Agent, View Client, or View Transfer Server."