This message was deleted.

Using it for all Citrix products

yeah i used ms sql always on for my XD site in my lab and used it in production enviroments many times. Even got a Youtube vid on the setup

Can you pls share

I saw ur blogpost - Configure a file share witness is mandatory?

it depends what your trying to do i only used a file share witness as i wasnt using shared storage. If you got shared storage and want to use failover cluster instances you have to install the clustered install of SQL

Ok

clustering especially with VMware brings a whole another bunch of issues such as clustering in a box if using SCSI bus sharing (both nodes must run on same host hence cluster in a box). You can use RDM's to get round that limitation but then RDM's bring there own issues

Let me check YT video and if i have any query will ping here

@Salim Hurjuk https://patrickvandenborn.blogspot.com/2018/01/microsoft-sql-and-microsoft-sql.html?m=1

Thanks @Rody Kossen

We're using SQL AlwaysOn Availability Groups for both CVAD and PVS and using the file share witness. Pair it with group managed service accounts so you don't have to mess with changing the service account password periodically.

I use the Cloud Witness feature, but I wouldn't need to at this point. Originally put in place when I built the cluster across data centers, but that ended up being less that ideal in the long run and split them into two clusters and use Distributed AGs for DR across Data Centers.

Cloud Witness will not work for me

I know a bit late on this thread. I do not use a file share witness. I use a 3 node cluster in majority node mode. It will give multiple copies of the DBs and tends to be a little more redundant for an always on situation. Key to that is to never have more than sql box shutdown at a time. SQL is installed independently on each server and not in a shared cluster. Each has its own local storage as well