| Track: | Enterprise Database Administration and Deployment |
|---|---|
| Level: | 200 (Intermediate) |
| Abstract: | 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, and 2012. |
| Goals: |
|
This presentation has been/will be delivered at the following event(s):
| Version | Date | Event |
|---|---|---|
| 1.1 | 2009-03-18 | GFWSSUG user group meeting |
| 1.2 | 2009-04-16 | NTSSUG user group meeting |
| 1.3 | 2009-08-01 | SQLSaturday #17 |
| 1.4 | 2009-10-10 | SQLSaturday #25 |
| 2.5 | 2010-05-22 | SQLSaturday #35 |
| 3.6 | 2010-11-09 | 2010 North American PASS Summit |
| 3.7 | 2011-01-29 | SQLSaturday #57 |
| 3.8 | 2011-02-24 | Immersion Event on Internals and Performance – Dallas, TX, US: February 21-25 |
| 3.9 | 2012-05-11 | PASS SQLRally 2012 Dallas |
The following Zip files contain the downloadable presentation materials (slides, code, and handout(s)):
- Release 3.0009.0001.0000 (2012-05-10)
- Release 3.0006.0003.0053 (2010-11-17)
- Release 3.0006.0002.0051 (2010-11-08)
- Release 2.0005.0001.0042 (2010-10-27)
