Advanced SQL Server Analysis Services (SSAS) & Performance

Course Code: SQSAAS
Currency: SQL Server 2005 & SQL Server 2008
Duration: 3 days
Level: Advanced
Audience: Developers, DBAs and capacity planners.
Prerequisites: Completion of our course 'SQL Server Analysis Services 2005/2008' (SQSSAS) or equivalent knowledge.
Summary: This course emphasises improving the quality of the end-user experience by equipping the technical support team (developers, DBAs, etc.) with the requisite SSAS skills to design, implement, monitor and tune:
  • Dimension attributes
  • Analysis Services query (MDX) performance
  • Processing performance
  • Aggregations performance
  • Indexes
  • Partitioning
  • Etc.
Objectives: Upon completion of this presentation, the participant should be able to diagnose SSAS performance problems and design and implement, monitor and tune per the facilities under 'Core Topics' in the detailed outline.
Format: Lecture and hands-on (about 55%).
View full outline in PDF formatDetailed Outline Bookmark and Share

print  |  top of page