Event Information

Share this event

Date and Time

Location

Location

Microsoft Corporation

3025 Highland Parkway

#300 - MPR II

Downers Grove, IL 60515

View Map

Event description
September User Group Meeting - Diagnosing and fixing deadlocks in SQL Server

About this Event

AGENDA:

5:30PM - Doors Open

6:00PM - Meeting Start with Dinner, Networking, & Open Q&A (bring your questions!)

6:30PM - Announcements, Sponsor Presentation, & Main Presentation

TITLE:

Diagnosing and fixing deadlocks in SQL Server

ABSTRACT:

You know how locking works in SQL Server, but now you are tasked with diagnosing and fixing deadlocks. How do you take the knowledge you have and apply it to address deadlocks in your production database?

In this session, we will discuss how you can use free tools to detect and analyze deadlocks in your system. We will do a deep dive on deadlock XML with an eye toward interpreting the information automatically collected by SQL Server when the free tools fall short.

Attendees will leave with the understanding they need to develop solutions to deadlocks in their systems.

SPEAKER BIO:

Jake has been a T-SQL developer since 2013, starting after he jumped ship from an academic life as a mathematics professor to the software industry. He focuses on solving difficult concurrency problems, large scale data warehouse ETL processes, data conversions, and understanding SQL Server optimizer behavior.

Share with friends

Date and Time

Location

Microsoft Corporation

3025 Highland Parkway

#300 - MPR II

Downers Grove, IL 60515

View Map

Save This Event

Event Saved