SQL Server Performance Tuning Essentials
Course Code: SSPTE
Course Duration: 1 Day
Overview
This one-day hands-on, instructor led course will guide you
step-by-step through the numerous aspects of performance tuning and
optimization in SQL 2005, 2008 and 2008 R2. You will learn how to
write high performance queries, allowing the optimizer to use the
most efficient query plan, and diagnose and correct performance
problems with already existing queries. During the day you will
also explore stored procedure optimization and T-SQL programming
best practices. The practical exercises are structured around SQL
Server Management Studio, SQL Server Profiler and other
sophisticated tools.
Who Should Attend
This course is designed for SQL Database Application Developers,
Database Administrators and Database Architects involved in tuning
queries.
Course Objectives
After completing this course, students will be able to:
- Learn techniques to detect performance problems
- Discover performance tools and monitoring techniques
- Write queries which help the Optimizer choose the most
efficient query plan
- Optimize stored procedure performance
- Implement debugging and error trapping
- Develop MDX-driven reports in SQL Server Reporting
Services
Course Prerequisites
Before attending this course, participants should have:
- a good understanding and practical experience of SQL Server
programming and administration.