Analysis Services Multidimensional

• Hany Helmy

  SSChampion

  Points: 13921

  More actions

  February 6, 2014 at 4:04 am

  #1686515

  Carlo Romagnano (2/2/2014)

  ---

  I also found this doc from MSDN that explains the answer

  SSAS2005PerfGuide.doc

  +1

  Thanks & Best Regards,
  Hany Helmy
  SQL Server Database Consultant

• sqlnaive

  SSCoach

  Points: 17437

  More actions

  February 11, 2014 at 2:01 am

  #1687806

  Hany Helmy (2/6/2014)

  ---

  Carlo Romagnano (2/2/2014)

  ---

  I also found this doc from MSDN that explains the answer

  SSAS2005PerfGuide.doc

  +1

  +1

  I have practiced on some basic SSAS and this is new territory for me. So giving some good searching for it helped me. I reached the above link which clarified. Need to study some more on this.

• sneumersky

  SSCertifiable

  Points: 7667

  More actions

  February 11, 2014 at 8:30 am

  #1687937

  If you are on SQL 2005, then use that document; otherwise, quite a few enhancements have been made to the SSAS Engine since then. There is now a consolidated Analysis Services Performance AND Operations guide applicable to SQL Server 2008 through 2012 (multidimensional mode only).

  There is a separate document for performance tuning the SSAS tabular model, and hardware considerations are quite different than the classic multi-dimensional model. I did not attend PASS 2013, but I know Greg Galloway spoke about the tabular performance tuning white paper at the conference.