HomeSQLServerPedia SyndicationCreate quick queries quickly with SSAS in Azure

Comments

Create quick queries quickly with SSAS in Azure — 6 Comments

  1. Hi James,
    Thanks for info. When you say high availability can be done in future, does that means shared storage for ssas fci cluster will be released soon? Otherwise azure ilb wouldn’t have a listenre IP address for HA, am I right or am I missing a trick? Though we already looked into third party shared storage stuff.

    Thanks

    • Hi Ahsan,

      High availability for the cube involves creating another VM with SSAS installed, and syncing a cube on each VM (so two copies of the data). There is no shared storage involved.

  2. Hi James,
    I’m curious as to why you have suggested the IaaS approach for this when we now have Azure Analysis Services in PaaS. Surely this would be a quicker route?

    Cheers

  3. Yes but how would u handle 2 different server names as these will be two different machines e.g. we have 3500 users who use power bi desktop, connecting to ssas tabular cube, where do they connect to machine1 or machine 2? As there is no cluster and no single listenre doesn’t this create massive problems and trouble some for users as they dont know which machine to connect to? Again tool power bi desktop is not specific it can be any tool, could you please put some light on it. Thanks

Leave a Reply

Your email address will not be published. Required fields are marked *

HTML tags allowed in your comment: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>