Deploying, Operating and Tuning an Analysis Services 2008 Solution  |
|
Course Overview |
| | During this 3-day course, you will learn to deploy, operate and tune an Analysis Services solution. You begin by learning how to prepare for the successful deployment of an Analysis Services solution. You will then learn to update data in a production environment while minimizing its impact on performance. Finally, you will learn to collect and analyze data to improve processing and querying performance.
Technologies Covered
- SQL Server 2008 Analysis Services
- Network Load Balancing
- SQL Server Profiler
- SQL Server Management Data Warehouse
|
| Objectives |
| | | Upon completion of this course, the student will be able to:
- Deploy an Analysis Services project from development to test and production
- Synchronize changes over time between development, test and production
- Determine appropriate hardware resources and software versions for your production environment
- Plan for security and availability requirements
- Update dimension and partition data while minimizing the impact on availability and performance
- Troubleshoot deployment and processing errors
- Utilize a scale-out architecture for availability and performance
- Monitor an Analysis Services solution for availability, performance and usage
- Diagnose and resolve query performance issues
- Diagnose and resolve processing performance issues
|
Audience |
| | This course is intended for IT Professionals responsible for deploying, operating and tuning an Analysis Services solution. The target audience for this course is IT professionals and business intelligence developers who want to successfully deploy and operate well-performing Analysis Services solutions.
|
Prerequisites |
| | Before attending this course, it is recommended that students have the following skills:
- Experience using Business Intelligence Development Studio to develop Analysis Services projects
- Experience using SQL Server Management Studio to manage an Analysis Services database
- Experience writing T-SQL and MDX queries
- Experience collecting performance monitor counters
- Experience collecting SQL Server Profiler traces
|
| Course Number |
| | SQMDepOpTun08
|
| Course Length |
| | 3 Days
|
| Course Price |
| | $2,350.00
|
| Category |
| | 5
|
| Topics |
| | | Day 1
Module 00: Housekeeping
- Introductions
- Course Hours
- Facilities
Module 01: Deployment Considerations
- Hardware and Scalability Considerations
- Lab 01A: Testing an I/O Subsystem
- Lab 01B: Stress Testing/ Workload Analysis
- Operating System Considerations
- SQL Server 2008 Considerations
- Installation Considerations
- Lab 01C: Documenting an Installation
- Security Considerations
- Availability Considerations
- Scalability Considerations
- Deployment Methods
- Lab 01D: Deploying to a Production Environment
- Deploying Changes
- Lab 01E: Deploying Changes to a Production Solution
- Troubleshooting Deployment Problems
Module 02: Updating Dimension and Partition Data
- Dimension Processing Considerations
- Lab 02A: Processing Incremental Dimension Data Changes
- Partition Processing Considerations
- Lab 02B: Processing Incremental Partition Data Changes
- Updating Aggregations
- Lab 02C: Using UBO to Update Aggregations
- Troubleshooting Processing Errors
- Lab 02D: Dirty Data and Incremental Updates
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: Implementing Query Scale Out
- Implementing Read-Only Databases
- Lab 04A: Setting Up Read-Only Databases
- Utilizing Server Sync / Robocopy
- Lab 04B: Synchronizing Database Files
- Configuring NLB
- Lab 04C: Utilizing NLB for Query Scale Out
Module 05: Monitoring and Analysis Services Solution
- Understanding Available Tools
- Monitoring for Availability
- Lab 05A: Verifying Service Availability
- Monitoring for Performance
- Lab 05B: Collecting Query Performance Data
- Lab 05C: Collecting Processing Performance Data
- Monitoring for Capacity / Trends
- Auditing User Access
- Auditing Administrative Activities
Day 3
Module 06: Enhancing Query Performance
- Understanding Query Architecture
- Diagnosing Problems
- Lab 06A: Identifying Design Problems
- Optimizing Dimensions
- Lab 06B: Modifying Dimension Properties for Performance
- Maximizing Aggregations
- Lab 06C: Identifying and Adding Useful Aggregations
- Utilizing Partitions
- Lab 06D: Partitioning
- Writing Efficient MDX
- Lab 06E: Improving Query Performance
- Cache Warming
- Lab 06F: Warming the Cache
- Advanced Techniques
Module 07: Enhancing Processing Performance
- Processing Architecture
- Diagnosing Problems
- Dimension Processing
- Lab 07A: Analyzing and Improving Dimension Processing Performance
- Partition Processing
- Lab 07B: Analyzing and Improving Partition Processing Performance
- Advanced Techniques
|