Performance Optimization 2-Day Masterclass
Views Photos from last years event
Delivered by internationally acclaimed SQL gurus, Paul S Randal & Kimberly L Tripp, this level 400 course is suited to people who have a number of years hands-on experience with the technologies and concepts or to those who have already completed a level 300 course in this area. It is a natural extension on the material covered in the SQL Immersion syllabus. The course will be delivered over the course of two intense days.
There are many aspects to performance tuning – some should be done when the database is designed, prototyped and tested, while others must be implemented over time. However, data churn varies, user needs change and what users told you during the development often turns out to be untrue...; the end result is that workloads do change. The key to long-term success is being able to handle these changes. How do you create a scalable environment that can handle these changes? Some maintenance changes are more for analyzing and troubleshooting where your bottlenecks are, while others are just general best practices that you should make sure you have implemented.
In this course, Paul and Kimberly focus on best practices in scalable code, monitoring system and resource utilization, as well as governing it and finally will analyze the health of your indexes and overall indexing strategy.
Remember you risk the design work you have already invested in going to waste if you don’t better understand plan caching and stored procedure optimizations! This course will cover how optimization works for stored procedures and when it might help to force some level of recompilation or even force a plan.
When dealing with resource troubleshooting, Paul and Kimberly will introduce three core concepts in understanding how your SQL Server is performing – waits, queues and locks – and they will explain how to investigate performance issues related to them. Following on from this two new features in SQL Server 2008 that allow resources to be constrained to protect critical workloads and perform very in-depth troubleshooting are introduced.
See below for information on the course and its content:
- Part I - Optimizing Procedural Code
- Module 1: Batches and Plan Cache
- Statement execution and plan caching
- sp_executesql and dynamic string execution
- Module 2: Optmizing Procedural Code
- Understanding stored procedures
- Understanding recompilation
- Creating an optimal plan
- Forcing plans & plan guides
- Part II - Resource Monitoring and Troubleshooting
- Module 1: Waits & Queues
- What are waits and queues?
- What should you be looking for?
- Module 2: Locking / blocking
- Locking overview
- Examples of blocking scenarios
- Trouble shooting blocking
- Blocking avoidance strategies
- Module 3: Resource governor
- Module 4: Extended Events
- Module 5: Performance Data Collection
- Part III - Are your index strategies working?
- Module 1: index cleanup
- Index usage and consolidation
- Module 2: Index health
- What is fragmentation
- Detecting fragmentation
- Removing fragmentation
- Module 3: Missing indexes
Save 15% when you register before April 30th, 2010.
-
Cost: €1,299
Dates: July 5th & 6th 2010
Venue: Microsoft Auditorium EPCD2, South County Business Park, Leopardstown