Performance Tuning and Optimization in Microsoft SQL Server 2008 R2 and SQL Server Code-Named "Denali"

The presentation will available at: SQLBlog.com

The Tuning Process
Monitoring
Collection of metrics
Storage of time stamped data
Calc

Troubleshooting
Id problem
Measure impact
Refine data collection

Tuning & optimizing
Correct problem
Improve the query

Testing and deploying
Validate
Move to production
Confirm with users

Make sure you test

Dynamic Management Views now called "Objects"
See the web site above for categorized objects

Extended Events - tracing and profiling. Extended Events only exist in "Denali"

In conclusion the are a huge amount of objects and tools to tune our SQL Server 2008 R2. Use the website for list that was discussed. In the coming year, I would like to do more tuning to increase performance in SQL Server and our apps.

Location:TechEd 2011