Home » sqlCat » Technical Notes » Analysis Services Load Balancing Solution
Options

Technical Notes

Analysis Services Load Balancing Solution

Rate This
8 Feb 2010 9:03 PM
  • Comments 6
Author: Carl Rabeler
Contributor: Josh Caplan
Reviewers: Prem Mehra, Denny Lee, John Desch, Wayne Robertson, Steve Pontello, Thomas Kejser
 
ASLB is a custom Analysis Services load balancing solution that consists of a load balancing Web service backed by a SQL Server load balancing metadata database to load balance MDX queries across multiple query servers. The metadata database contains information about each Analysis Services query server to which queries can be redirected by the Web service.
Load Balancing Web Services
Location of the Analysis Services load balancing (ASLB) Web application. Internet Information Services (IIS) is required on these servers. These servers can use Network Load Balancing (NLB) for failover.  For more information about using Network Load Balancing, see Network Load Balancing Deployment Guide.
Load Balancing metadata db
Location of ASLB database. The ASLB database can be mirrored for failover (optional, but recommended for availability). For more information about mirroring, see Database Mirroring Best Practices and Performance Considerations.
AS servers with IIS and MSMDPump
Location of Microsoft® SQL Server® Analysis Services databases. IIS and MSMDPump.DLL must be installed on each of these servers.
 
 
 
 
 
 
 
 
Important: For more information, including a discussion of the problems that are solved by ASLB that are not solved by other software and hardware load balancing solutions, see the Microsoft SQL Server 2008 Analysis Services Consolidation Best Practices paper on the SQLCAT web site.
To Get Started: Download the setup instructions and solution files at: http://sqlsrvanalysissrvcs.codeplex.com/SourceControl/changeset/changes/81732
, , , ,
Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment
  • Post
Comments
  • Twitter Trackbacks for Analysis Services Load Balancing Solution - Technical Notes [sqlcat.com] on Topsy.com
    9 Feb 2010 5:19 AM

    Pingback from  Twitter Trackbacks for                 Analysis Services Load Balancing Solution - Technical Notes         [sqlcat.com]        on Topsy.com

  • 25 Aug 2010 12:41 PM

    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

  • 27 Sep 2010 5:33 AM

    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!

  • 27 Sep 2010 4:20 PM

    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.

  • Deepak Patel
    18 Aug 2011 9:25 AM

    Also consider NetScaler DataStream for you SQL server Load balancing needs

    www.citrix.com/.../subfeature.asp.

  • Oliver Steel
    28 Sep 2011 6:24 AM

    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.

Page 1 of 1 (6 items)
Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment
  • Post