Please join us January 19th, from 2:30PM – 4:00PM at the Microsoft office in Corporate Woods.
Topic: Lock, Block, and Two Smoking CPUs
This session is about Dan Maenle’s personal experience rewriting the locking mechanism that his company was using. As well as migrating from a locking table to using the sp_getapplock stored procedure. This session will cover the ups and downs that he experienced in the transition.
Dan will also discuss how this technique can be a better performing approach to gaining locks that could be used by the application or other queries to optimize concurrency.
About Dan:
Daniel Maenle is a Database Administrator at Jack Henry & Associates and has been working with SQL server since 2011. He spoke at SQL Saturday Kansas City last year presenting on this same topic.
Please note, this will be an afternoon meeting.
Meeting Schedule for Thursday, January 19th, 2017:
- 2:30 - 2:40 - Greeting and Housekeeping
- 2:40 - 3:40 - Presentation
- 3:40 – 4:00 - Wrap up and Q&A
We look forward to seeing you all soon!
KC SQL Server User Group web site: http://kansascity.sqlpass.org/
Posts
0 Response to "January 19: SQL Server User Group Meeting - Dan Maenle - Topic: Lock, Block, and Two Smoking CPUs"
Post a Comment