SQL Server Performance

Analysis Server architecture

Discussion in 'SQL Server 2005 Analysis Services' started by nihalek, May 1, 2007.

  1. nihalek New Member

    We have a large cube (over 500GB) and several other relatively small cubes built using AS 2000. We are now in the process of upgrading the environment. Basically we are going to buy new infrastructure and use AS 2005. And the OS is XP. The large cube is the one that is widely used in the company by at least over 200 people. Small cube has very few users. My question is what is the best architecture we can use

    1. Whether to use one large machine and then have one instance of AS. All cubes are to be migrated to this instance. Issue with this option, we can not makesure we give more resources to the important cube.

    2. Have multiple instances of the AS running on the server. Use MS Resource manager (new product shipped with XP server) to manage the resources. Has anyone used MS resource manager or aware of any issue with it ?

    3. Use clustered environment - I do not know how use this to allocate more resources to the important cube. Any thoughts ?



    Much appreciate, any pointers on what we are trying to achieve here .

    Thank you
  2. satya Moderator

    I would go with option 2 by testing it before hand, if you are using 64bit then you will be better off to have an advantage of addressing the resource issue.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  3. nihalek New Member

    Thanks Satya, assume that the server has 8GB or more memory, If we have multiple instances on AS running, can we allocate 3GB (that's the max AS can access) for each instance.
  4. satya Moderator

    Depends on the operating system edition used, better to go with WIndows 64 bit for max utilization.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page