SQ-310 - Advanced Microsoft SQL Server 2008 Analysis Services R2 (SSAS)
Course
SQ-310
Price:
$1,895.00
Software Assurance Value:
Not Eligible
Duration:
2 Days
Description
This two-day SSAS course is based on our three-day Deploying, Operating, and tuning an Analysis Services 2008 Solution.
It focuses on advanced concepts for both operating and tuning SSAS in an enterprise environment. This course takes IT professionals, DBAs and developers to
a deeper level of SSAS skills maturity. By the end of the course, students will have the knowledge on how to architect complex SSAS solutions, stress test an SSAS solution,
implement load balancing, optimize dimension and cube processing, and optimize query performance.
Return to Top
Audience
This course is intended for solution architects, DBAs, and
developers who work with SSAS and are responsible for architecture, performance,
and operation of an SSAS solution.
Return to Top
Prerequisites
Before attending this course, it is recommended that
students have the following skills and experience:
- Designing an SSAS solution using BIDS
- Managing an SSAS solution using SSMS
- Analyzing Traces Files using SQL Server Profiler
- Analyzing Performance using Performance Monitor
Return to Top
Course Objectives
Upon completion of this course, the student will be able
to:
- Architecting an SSAS solution for performance and
availability
- Identifying SSAS query and processing performance
bottlenecks
Return to Top
Course Outline
Day 1
Module 01: Deployment Considerations
- Hardware and Scalability Considerations
Lab 01A: Stress Testing using ASCMD
- Operating System Considerations
- SQL Server 2008 Considerations
- Installation Considerations
Lab 01B: Configuring HTTP Access
- Security Considerations
- High Availability Considerations
- Deployment Methods
Lab 01C: Deploying a Solution to a Production Environment
Lab 01D: Deploying Changes to a Production Solution
- Troubleshooting Connectivity Problems
Module 02: Updating Dimension and Partition Data
- Accessing Data Sources
- Database and Cube Processing Overview
- Dimension Processing Considerations
Lab 02A: Processing Changes to Dimension Data
- Partition Processing Considerations
Lab 02B: Processing Changes to Partition Data
Lab 02C: Using UBO to Update Aggregations
- Troubleshooting Processing Errors
Day 2
Module 03: Maintaining Availability
- Planning for Disaster / Backing up Data
Lab 03A: Backup and Detach
- Recovering from Disaster / Restoring Data
Lab 03B: Restore and Attach
- Implementing Failover Clustering
Module 04: Enhancing Query Performance
- Understanding Query Processor Architecture
- Diagnosing Bottlenecks
- Optimizing Dimensions
- Maximizing Aggregations
- Utilizing Partitions
- Writing Efficient MDX
- Cache Warming
- Advanced Techniques
Module 05: Enhancing Processing Performance
- Basics of Processing
- Diagnosing Problems
- Improving Dimension Processing
- Improving Partition Processing
- Advanced Techniques
Return to Top
