Pingback from Twitter Trackbacks for Analysis Services Load Balancing Solution - Technical Notes [sqlcat.com] on Topsy.com
On Page 14 of the setup guide, in section 4.1.4, it should read "“Change the property values for the connectionString properties for your environment by replacing the Server1 and Server2 placeholders with the SQL Server server names" not the Analysis Services server names
hi carl, i don't see in the document how an excel client can connect ASLB. using excel, how can a customer who implements ASLB connect to their cubes? thanks!
Section 5 of this setup document - at step 5.2 provides the connection string that you would use from Excel to the web server, which redirects the Excel query to your SSAS server.
Also consider NetScaler DataStream for you SQL server Load balancing needs
Database Load Balancing is a quite complex topic as such but you have explained them in a most effective way. Every developer need to deal with this issue over a period of time as database scalability is a common problem which is faced and a person need to go for database sharding for dealing with the different type of scalability issues.