Hillsborough SQL User Group

Welcome to the Hillsborough SQL Server Chapter

The Hillsborough SQL User Group is interested in sharing information about Microsoft SQL Server and related topics.  The meetings are free to all who wish to attend.  Food and drinks will be served at most meetings.

We meet at the Corporate Center I at 6:30pm on the last Thursday of every month except November and December. Food usually arrives at 6:00pm to allow networking until the meeting starts at 6:30pm.  The address is 2202 North Westshore Boulevard, Suite 122, Tampa, FL.

We look forward to seeing you there. 

Next Meeting

Thursday,

July

26

Dmitri Korotkevitch presents Deep Dive into Blocking and Deadlock Troubleshooting

  • In-Person @ 2202 North Westshore Boulevard Tampa, Florida, United States (map)
  • 18:30 - 21:00 Eastern Daylight Time
  • Language: English

Parking is available at the west entrance (airport side). Please follow the Visitor parking signs past the garage and around the fountain.

 

Food will be provided and will arrive at 6:00 pm and the meeting start at 6:30 pm. Also, plan to join us at Kona Grille for the meeting after the meeting for more networking.

Featured Presentation:

Deep Dive into Blocking and Deadlock Troubleshooting

Dmitri Korotkevitch, Principal Database Engineer chewy.com

SQL Server Concurrency Model is, perhaps, the most confusing and least understood part of SQL Server Internals. Blocking issues and deadlocks occur unexpectedly and negatively impact performance and user experience in the systems. Nevertheless, this model is well-structured and easy to understand when you analyze it from lock types and their lifetime and compatibility standpoint. This, two-part session will explain why blocking and deadlocks occur and how to troubleshoot them in your environments. First, it will provide the overview of SQL Server Concurrency Model and describe SQL Server locking behavior and root-causes of typical blocking issues. Next, the session will discuss how to capture and troubleshoot them using standard SQL Server tools, and how to simplify the analysis using Blocking Monitoring Framework developed by Dmitri.

About Dmitri:
Dmitri Korotkevitch is a Microsoft Data Platform MVP and Microsoft Certified Master, author of Pro SQL Server Internals and Expert SQL Server In-Memory OLTP (http://amazon.com/author/dmitri-korotkevitch). with years of experience working with SQL Server as an Application and Database Developer, Database Administrator, and Database Architect. Dmitri specializes in the design, development, and performance tuning of complex OLTP systems that handle thousands of transactions per second around the clock. He blogs at: http://aboutsqlserver.com.

PASSChapterLogo.jpg

sql_micro_sm.gif

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids