Post reply

Configuration question

  • February 4, 2005 at 3:14 am

    #109310

    What are the advantages / disadvantages of having Analysis Services installed on the same server as the SQL server? The assumptions are; all cubes are MOLAP and the SQL Servers are in the same location as the Analysis servers.

     

    Stuart

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • February 7, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • February 7, 2005 at 4:00 pm

    #541043

    The things I would be most concerned about are

    • contention over RAM.  not so much a problem if everything you're doing is really small, but if you start to push the boundaries, you wil want as much of the 4gb (well 3 really) to AS as possible
    • contention over dik read/writes.  If you've set up you're DB 'textbook' then you will prob have disk for logs, disk for temp DB, disk for data files, disk for OS (have I left any out?), the bottom line is you're trying to avoid reading and writing to the same physical disk at the one time.  If your AS and SQL are on the same machine and you're using local disk, you are likely to run into an issue at some point with the read/write bottleneck.  If you're using SAN, that's a different story, but make sure your operations people have set it up appropriately for your requirements.
    • the potential for disk space issues, again, more of an issue when using local disk
    • depending on your query tool, you may slow down your sql install because of the PTS client running on the server.
    • Depending on the complexity of your cubes, As could use large amounts of CPU to resolve queries, taking it away from SQL
    • SQL has much better settings capabilities for RAM, CPU etc, but by default it sets up to use as much as it can, so in a contention war, SQL will normally win out.

    Bottom line for me, if it's a POC (proof of concept), a very small site (data wise), or you just can't gt the budget (which equates to internl POC anyway) then go the single server, otherwise split it out. 

    Steve.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply