This is a little bit embarrassing… I can’t upload the zip archive files with my presentation materials! Apparently WordPress.com, the host of this blog, does not allow zip files: Accepted Filetypes. My presentation materials include a mixture of PDF files, PowerShell and T-SQL script files, XML deadlock graph files, and a few other file types. I’ll post what I can (the PDF files), now, and then figure out a contingency plan or work-around tomorrow. Any suggestions would be appreciated!
Posts Tagged ‘deadlocks’
My First Forum Contribution
2009-10-12NOTE: This post was composed on an airplane on 2009-10-11.
As I’ve mentioned, a goal for the year has been to begin participating in technical forums, answering questions for other IT professionals and developers. I set up a few accounts/profiles last weekend and resolved to answer at least one thread over the course of the week. It was a busy week!
Well, last night Tim (blog, Twitter) and I left the SQLSaturday #25 afterparty some time between 7:30 and 8:00 p.m. We were having a great time, but the weariness from traveling and the lack of sleep was catching up with me.
We got back to the hotel, relaxed briefly, then broke out the laptops. Tim planned to download videos about the Tableau product suite, a very impressive "visual analysis and data visualization" tool that had been demonstrated during the conference, for the flight home. I planned to continue working on my SQLDiag presentation and hopefully compose a blog post or two as well.
Instead, we got caught up in discussion, visiting such varied topics as: SQLSaturday #25, SQLSaturday #17, the North Texas SQLSaturday (that is being planned), the NTSSUG leadership, presentation styles, career goals, marriage, books, friendships, our jobs, the folly of youth (specifically not applying ourselves in school), and our mutual admiration for Tim Mitchell (blog, Twitter). It was a lot of fun!
A little after 11:00 p.m. (I think), I suddenly remembered my forum-post-for-the-week-of-October-4th goal, which hadn’t been achieved. I decided not to let it slip, so I took action.
First, I needed to find a good thread to which I could contribute. I brought up the ServerFault, SQL Server Central, and TechNet forums in different browser windows and began searching. I wasn’t quite sure the best way to conduct the search, so I started by only including threads that hadn’t been answered yet. I skimmed through the remaining post titles and saw a few about deadlocks. I quickly latched onto that topic and refined my search. Moments later, I found my target: "how to analyse deadlock graph and deadlock xml ?" [sic].
One of the suggestions in my deadlocks presentation is to sanitize the deadlock graph and then reach out to the SQL Server community (by way of forum of newsgroup) or send the graph to a colleague for help (at least until attaining proficiency with deadlock troubleshooting), so this was a great fit.
I copied the deadlock graph’s XML content from the forum post into a text file and then changed the extension of the file from "txt" to "XDL." Doing so made it so that SQL Server Management Studio would automatically open the deadlock graph and render a diagram of the deadlock. I also reformatted the XML contents so that it was easier to read.
I figured out the reason for the deadlock (as much as one can without access to the system and/or schema) pretty quickly, but the write-up took quite a while. I wanted to include enough information and references that the poster would learn from the answer, and not just take it and be no better off in the future.
Unfortunately it was past midnight by the time that I posted the answer, which meant that I hadn’t technically met my goal of posting an answer during the week of October 4th. However, I have rationalized that I did reach my goal, as it was still before midnight in the Central Time Zone (in which the goal has been set). 
Cheap? Yes… but I’m still happy with it!
I plan to answer at least two forum questions this week.
Now for the punch line: The thread that I answered was posted on January 23rd*, so my effort probably has little-to-no value for Anjali Vishwakarma! I’ll chalk that up to being a forum newbie. Tim tells me that this behavior has its own, very fitting and humorous term on ServerFault/StackOverflow. Hopefully the answer will be useful to somebody else, in the future, when they are researching deadlocks.
* I noticed the dates in the deadlock graph, thought that it was strange that the poster needed help with a deadlock from so long ago, but failed to make the connection that I was dealing with a long-forgotten thread. Remember that I said I was sleep deprived. 
Speaking at SQLSaturday #25
2009-10-04This coming weekend, I head to Gainesville, Georgia for SQLSaturday #25. This will be my second SQLSaturday event to attend, and this time I will be presenting two sessions:
- Deadlock Detection, Troubleshooting, & Prevention at 8:30 a.m.
- Leveraging SQLDiag for Efficient Troubleshooting at 11:00 a.m.
The latter will be my first public delivery of that presentation, the same one that I will be giving in less than a month at the PASS Community Summit 2009! I hope to get a lot of good feedback so that I can continue to refine it.
As before, with SQLSaturday #17, a secondary reason for attending is to gain greater insight into the workings of a SQLSaturday event, in order to apply the experience to the North Texas SQLSaturday event that we are planning. I learned a great deal from a great blog post by Stuart Ainsworth (blog, Twitter), so it will be great to see him in action (he’s also the event coordinator of SQLSaturday #25).
I’m fortunate to get to travel with another friend from the user group, Tim Costello (blog, Twitter). This is going to be a fun trip!
Speaking at SQLSaturday #17
2009-07-31I am currently in-transit (or was when I wrote this) to Baton Rouge, Louisiana for SQLSaturday #17. As described so many other places, SQLSaturday events are free, one-day mini-conferences that provide SQL Server training to the local development and IT community.
After having learned about the SQLSaturday concept a year or two ago, I’ve wanted to attend one. Unfortunately, there haven’t been any in Texas*, despite our thriving SQL Server community.
This probably seems obvious, but it never occurred to me to travel to one. It wasn’t until I heard that Tim Mitchell (blog, Twitter), a friend from our user group, was doing just that, presenting to (at least) two SQLSaturday events in Florida recently. What a great idea&em;SQLSaturday is certainly worth some traveling! My wife agreed, and we began budgeting for such a trip.
Tim let me know that he was presenting at SQLSaturday #17 and invited me along. I decided to join him, based largely on the following reasons: my long-standing desire to attend a SQLSaturday, my goal to practice delivering technical presentations as much as possible before my PASS Summit session, and the change to observe the organizing/running of a SQLSaturday (to serve as a model for our own*). I submitted an abstract to the call for speakers and delighted that it was accepted. I will be delivering my Deadlocks: Detection, Troubleshooting, and Prevention presentation that I’ve already given to both local user groups. The presentation details were truncated by the SQLSaturday web site, so I’ll post the complete details here:
| Session Name: | Deadlocks: Detection, Troubleshooting, and Prevention |
| Track: | Infrastructure |
| Description: | 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 demonstrate approaches for handling deadlocks in SQL Server 2000, 2005, and 2008. |
I’m really looking forward to it! I’m sharing a rental car and hotel with Time, so I’m glad that I’ll get the chance to know him better too.
If all goes well, I’ll try to attend SQLSaturday #21 or #25 in October, presenting my Leveraging PSSDiag/SQLDiag for Efficient Troubleshooting topic. Stuart Ainsworth (blog, Twitter) is courting me for SQLSaturday #25, so that one is in the lead right now. Another friend from NTSSUG, Tim Costello (blog, Twitter) is also planning to attend SQLSaturday #25, so that is an additional reason to go.
* I’m part of a team (the NTSSUG board plus Tim Mitchell) working on bringing the SQLSaturday experience to North Texas. We had a great conference call with Andy Warren (blog, Twitter), a founder of SQLSaturday, and plans are starting to come together. More details will follow in the coming weeks.
