12/3/2012 4:47:04 PM
Like a CSI Investigator you can examine the evidence left behind by Transact-SQL code execution to optimize performance! This evidence, in the form of execution plans, can be found in the plan cache.
In this session Victor Isakov (MCA, MCM, MCT, MVP) will show how you can use XQuery to examine the plan cache to find potential performance problems. This technique can be used to reduce table scans, troubleshoot parallelism problems, determine unused indexes and identify which Transact-SQL code should be optimized.
Speaker: 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, December 5, 2012