Home >
SQL Server >
Advanced SQL Server Analysis Services (SSAS) & Performance
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%).
|
Detailed Outline |
|