Deadlock Detection, Troubleshooting, and Prevention
As an enterprise application grows and load increases, some concurrency issues are bound to surface. Deadlocks are one of the more aggravating of this class of problems. Fortunately, each release of SQL Server includes better tools for troubleshooting deadlocks. Trevor will provide a strong foundation on deadlocks and then demonstrate approaches for handling them in SQL Server 2000, 2005, 2008/2008 R2.
Terremark Worldwide, Inc.
SQL Server Escalation DBA
Trevor Barkhouse is an Escalation DBA for Terremark Worldwide, Inc., a leading global provider of IT infrastructure services. His passions are automation, performance tuning, and troubleshooting. Trevor is very active in the community. In addition to recently finishing a term on the board of directors of the North Texas SQL Server Users Group, he has spoken at many user group meetings, four SQLSaturday events, and at the 2009 PASS Community Summit.
Register Now for PASS Summit 2010!