3/6/2008 11:12:47 AM
Central to the performance of any SQL Server system is how queries are being processed by the database engine. Execution plans describe what steps SQL Server is taking to process a query so being able to understand this information is crucial to controlling SQL Server performance.
Whilst this topic is sometimes considered to be the domain of experts, a few simple techniques can significantly improve your ability to understand what is going on "in there", putting you in a position to control the performance of your SQL Server system.
In this session we will cover the fundamentals of how to obtain & read execution plans, including how to work out whether SQL Server is utilising good indexes and choosing efficient join techniques to process queries efficiently.
Greg Linwood is the Managing Director of "SQL Servants" - a dedicated SQL Server support business and also Australian Director of "Solid Quality Learning" - a specialist provider of SQL Server training. Greg has worked in a range of developer & DBA capacities with SQL Server since 1993 and was the first Australian to receive Microsoft’s SQL Server MVP award in 2003. He has gained significant expertise in SQL Server tuning and most of his professional time is currently spent tuning customer SQL Server systems. Greg is passionate about building high quality SQL Server community events in Australia and is one of the founders of the Australian SQL Server User Group.
Venue: Mechanics' School of Arts, Level 1, 280 Pitt St, Sydney |
Duration 5:30pm Share Ideas, Network with your Peers (with Pizza & Drinks), 6:00pm until 8pm Session |
On: Tuesday, April 8, 2008