Home » sqlCat » ToolBox » ASLB Toolkit
Options

ToolBox

ASLB Toolkit

8 Feb 2010 10:00 PM
  • Comments 5
Author: Carl Rabeler
Contributor: Josh Caplan
Reviewers: Prem Mehra, Denny Lee, John Desch, Wayne Robertson, Steve Pontello, Thomas Kejser
The ASLB toolkit 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
  • 25 Aug 2010 12:29 PM

    On Page 14, 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

  • 22 Mar 2011 3:43 PM

    Here are this and some other articles on SSAS Load Balancing:

    <a href="ssas-wiki.com/.../Articles

    ssas-wiki.com/.../Articles

  • 1 Sep 2011 5:15 AM

    Is there a new version of the ASLB?

    Is it possible to compile it in Visual Studio 2010?

    Thanks in advance.

  • annie yuan
    16 Mar 2012 10:08 AM

    Mr. Carl, try very hard, never works for me same SPN issue as we had when you were here , need your brain  :-)

  • Annie Yuan
    16 Mar 2012 10:10 AM

    Tiago, you have ASLB working in your place, I really need you idea.  thanks

Page 1 of 1 (5 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