30/07/2010 8:13:53 AM
How do you troubleshoot performance issues in SQL Server? What is the impact on performance when using DMVs, SET options, SQL Profiler or Perfmon? In this session Victor Isakov will answer these various questions as he goes through the main tools that DBAs can use to troublshoot performance, including SQLNexus, PAL, RML Utilities and SQLDiag. Victor will also briefly cover Performance Datawarehouse, missing indexes, query plans and the important new feature introduced in SQL Server 2008 - Extended Events.
[b]Speaker:[/b] Victor Isakov (SQL Server Solutions)
Victor Isakov is a Database Architect and Microsoft Certified Trainer who provides consulting and training services to various organizations in the public, private and NGO sectors globally, and been involved in different capacities at various international events and conferences. He has authored a number of books on SQL Server and worked closely with Microsoft to develop the new generation of SQL Server Certification and Microsoft Official Curriculum for both instructor led training (ILT) and e-Learning. He is one of the first IT professionals to get the Microsoft Certified Master and Microsoft Certified Achitect certifications globally.
Venue: Sydney Mechanics' School Arts |
Duration 12:00 - 14:00 |
On: Wednesday, 3 November 2010