About the Presentation
Deadlock Detection, Troubleshooting, & 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, and 2008.
Session Level: Intermediate
Trevor Barkhouse
Trevor Barkhouse is on the Database Implementation and Escalations team at Terremark Worldwide, Inc., a leading global provider of IT infrastructure services. He has a passion for automation, performance tuning, and troubleshooting. Trevor is very active in the SQL Server community, presenting to the North Texas SQL Server Users Group (where he also serves on the board of directors) and the Greater Fort Worth SQL Server Users Group.
Contact URL:
http://tnbarkhouse.wordpress.com/