Citrix Desktop - Design best practices for small business

[Christian Toledo]

I am building a Citrix Virtual Apps and Desktops 7 1912 environment for less than 50 users. Users access Windows Server Desktops that are locked down and controlled via policies. With past versions I opted for a simple design with a single Controller with SQL Express DB while leveraging SQL backups, VM backups, SAN snapshots and site to site replication for basic resiliency. Although I can greatly improve resiliency by putting the DB on dedicated and mirrored SQL Servers, it would come at an increase cost in licensing as well as add nodes that need support and would further extend the DR process. Do you guys feel SQL Express is adequate for a small business design? Or would you move the DB to SQL Servers with high availability DB solution? At the moment, I am leaning on using an existing SQL Server (without high availability) to host the DB and implement dual Controllers. Thank you much in advance.

[Diego Oliveira]

SQL Express has a size limit of 10GB. I recommend to move to a standard SQL:https://support.citrix.com/article/CTX140319

Check these others thread:

https://discussions.citrix.com/topic/390449-site-built-with-sql-express-change-to-sql-standard/

https://discussions.citrix.com/topic/384100-xendesktop-712-sql-express/