The next Minnesota SQL Server User Group meeting is next Tuesday on November 20. This month the presentation will be on SQL Server database locking and blocking. Be sure to register so that your name badge will be available for you at the Microsoft Technology Center when you arrive.
The sponsor for this month’s meeting is Dell Compellent.
Location: 3601 West 76th Street, Suite 600 Edina, MN 55437
Date/Time: Tuesday, November 20 from 4 to 5:30 p.m.
• URL: https://www.livemeeting.com/cc/usergroups/join?id=8DFJJB&role=attend&pw=Z-%3B%7D*t4%2Cn
• Meeting ID: 8DFJJB
• Entry Code: Z-;}*t4,n
- 4:00 – 4:10 : Registration / hospitality / networking
- 4:10 – 4:15 : From our Sponsor – Overview of Dell Compellent SAN
- 4:15 – 5:15 : Introduction to SQL Server Locking and Blocking
- 5:15 – 5:30 : Announcements and prize giveaways
Introduction to SQL Server Locking and Blocking (Kirby Richter, Dell Compellent)
What is locking? What is blocking? Why should you care? You want to update a million rows on production, you need to know what type of locks will happen so you can plan accordingly!
You are tuning a query and the normal duration is 1 second but recently it’s been taking over a minute. Is your process being blocked?
Let’s face it blocking is very common and as a good DBA you need to recognize when blocking is an issue and how to deal with it. This presentation will cover most of the gory details and includes several fun demos. You will learn how to check and monitor locking and blocking and how to deal with common issues.
And don’t forget, the SQL Lunch that was scheduled for October was rescheduled and will be next month for Friday, December 14 from 11:30 to 1:30 with me as the host – SQLFriends Lunch–Dec 14.