Network load balancing is recommended for high or escalating query and processing workloads. Analysis Services databases in a NLB solution are defined as read-only databases to ensure consistency across queries.. GeoPITS brings you the comprehensive details of Scalable read-only Analysis Services configuration's support in different versions & editions of SQL Server.
Version | Enterprise | Standard | Web | Express (Adv.) | Express |
---|---|---|---|---|---|
Version v2019 | |||||
Version v2017 | Yes | ||||
Version v2016 | Yes | ||||
Version v2014 | |||||
Version v2012 |
Network load balancing is recommended for high or escalating query and processing workloads. Analysis Services databases in a NLB solution are defined as read-only databases to ensure consistency across queries.
You can find more details about this version here