SQL Server Performance

Analysis Services Newbie

Discussion in 'SQL Server 2005 Analysis Services' started by jhoy, May 9, 2007.

  1. jhoy New Member

    Hello Guys,,


    I am a beginner in Analysis Services...

    And I need to evaluate which one in AS 2000 and AS 2005 is much convenient to used and applied in business processing..

    Please give me links for me compare and validate which is much useful for our applications.

    Some give me an advice with this...


    thnx,,,
    jhoy

    jhoy
  2. edarasatish New Member

    Sqlserver 2000 is also having analysis sevices but now 2005 having lot of features compared to previous versions so better to go for the 2005. DataMining is also became very easy and u can classify to any extend.....

    satish.e
  3. dineshasanka Moderator

    SQL Server 2005 has many more features. So I also prefer for SQL Server 2005 AS

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  4. satya Moderator

    See thishttp://sqlserver-qa.net/blogs/el/ar...-2005-analysis-services-operations-guide.aspx fyi.

    IMHO there is no such article availble on the web to evaluate the features between the 2 versions, as usual you will see more enhancement and deprecation on the latest release which is SQL 2005 AS and in this case only you can rely upon the Books online content. Moreover you have to clear about your business requirement & budget to allocate relevant (sensible) hardware for optimum performance.

    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. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  5. jhoy New Member

    I have decided to use 32-bit Analysis Services 2005 and I think tool is a lot more easier than the
    2000 version....

    If I had the time I will post the comparison between the two.

    jhoy
  6. satya Moderator

    That is by default as you will see many features associated with latest version, as suggested using the Operations guide you can be assured about selecting the relevant edition. Also if you ask anyone they would suggest to go with latest version if your requirement is a fresh one.

    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. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  7. Raulie New Member

    Very true, go with latest version why buy a 2000 volkswagen when you can purchase a 2005 Mercedes.

    Raulie



  8. satya Moderator

    [<img src='/community/emoticons/emotion-1.gif' alt=':)' />] Raulie, on that aspect I would go with Volkswagen for long run and reliability, not expensive Mercedes [<img src='/community/emoticons/emotion-2.gif' alt=':D' />].<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</i></font id="size1"></font id="teal"></center>

Share This Page