SQL Server 2005/2008 Advanced DBA Performance & Tuning

Level:
Intermediate-to-advanced

Audience:
SQL Server DBAs, capacity planners and system administrators.

Prerequisites:
Completion of our course SQL Server 2005/2008 DBA Fundamentals or its equivalent (e.g., on-the-job experience).

Summary:
After an in-depth discussion of SQL Server storage engine, the remaining, about 65%, of this hands-on course is dedicated to:

• Troubleshooting and problem-solving
• Performance and tuning optimization
• Tuning methodology and tools
• Best practices and performance:
  
  • Integration Services (SSIS), especially ETL
  • Analysis Services (SSAS)
  • Reporting Services (SSRS)

Objectives:
Upon completion of this presentation, the participant should be able competent to troubleshoot and resolve SQL Server performance issues as these relate to both OLTP and OLAP environments.

Format:
Lecture and hands-on (about 60%)