SQL Academy: SQL Performance Tuning and Optimization
SQL Academy is a series of FREE Level 300 technical training seminars being hosted by Microsoft. The topic has been revised and will now cover “SQL Performance Tuning and Optimization – Tools and Methodologies” and will be delivered by Bob Duffy MCA, SQL MVP.
-
Where:
Microsoft Auditorium (EPDC2), South County Business Park, Leopardstown, Dublin 18
-
When:
December 1st 2009 from 13:30 – 17:00
-
Suitable for:
IT Pros, DBA and Database Architects who are responsible for configuring SQL Server infrastructure.
This Session is focused on Tools and Techniques for SQL Performance Tuning and Optimization (PTO). The target audience is developers and DBA’s working with SQL Server and needing to identity and resolve performance issues.
Three one hour sessions:
- Real Time performance diagnostics tools
- Activity Monitor
- Perfmon
- DMV's
- SQL Trace
- SQL Performance Dashboard
- Sqldiag
- DAC connections
- 3rd Party SQL Monitoring Tools
- Waits and Queues Tuning Methodology
- Precision Query Tuning with RML Utilities
- Server Side Traces
- RML Utilities