Home > SQL Server > SQL Server 2005/2008 Advanced DBA Performance & Tuning

SQL Server 2005/2008 Advanced DBA Performance & Tuning

Course Code:	SQSDPT
Duration:	4.5 days
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%)
Detailed Outline

Course Schedule