14/04/2009 10:15:15 PM
Diagnosing SQL Server blocking and deadlocking is tricky business if you're not sure how to approach diagnosis or design effective solutions to these problems.
In this session, SQL Server MVP Greg Linwood discusses how you can efficiently diagnose blocking & deadlocking problems, whether your SQL Server platform is 2000, 2005 or 2008 (each has improvements in diagnostic capabilities & tools). Greg will also discuss how to design effective solutions once you've identified the source of your blocking or deadlocking problems.
Content for this session spans introductory through to advanced topics, including SQL Server Locking internals, DMVs, SQL Trace, DBCC commands and also SQL 2008's Extended Events (XEvents) which provide deeper information on blocking than was previously available in earlier versions of SQL Server. This session is also based on real world case studies & attendees are invited to bring questions along on the night.
If you have a SQL Server system that suffers from blocking problems & you're not sure what to do next, this is a great opportunity to come along, learn & ask questions from a highly experienced SQL Server Database Administrator!
About the presenter
Greg Linwood is the Managing Director of MyDBA - a dedicated SQL Server support business and also Australian Director of SQLskills - 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, leading the Melbourne SQL Server User Group.
Venue: Microsoft Level 5, Building 4, Freshwater Place, Southbank , Melbourne, VIC |
Duration 5:30PM pizzas & drinks for 6:00 start, approx 7:45pm finish |
On: Tuesday, 21 April 2009