Have you experienced slow down in your application because of blocking and wondered what you can do? This talk will cover the basics of concurrency starting with isolation levels including RCSI and snapshot isolation levels, lock escalation, locking granularity and deadlocks. We will follow thru this with diagnosing and troubleshooting the blocking issues and will conclude with general guidelines in designing application(s) for maximum concurrency.

Session Goals:

  1. Overview of blocking and concurrency in SQL Server. This is more of refresher to bring everyone on the same page.
  2. Use demos to show blocking including lock escalation and steps you can do minimize or eliminate blocking without any changes in the application.
  3. Use demos to show deadlocks and waits induced thru page latches and show how to monitor and troubleshoot.


Sunil Agarwal, SQL Server Tiger Team Microsoft

Sunil Agarwal is a seasoned professional with 30+ years of industry experience in databases. He has worked as developer/lead building relational database engine technology, as a tool designer/lead building backup/restore tools, as an application developer/manager enabling B2B commerce as e-learning, and now as a principal program manager for SQL Server for the last 14+ years. He currently works in the SQL Server Tiger Team. He has led some key features/technology such as columnstore Indexes, In-Memory OLTP, AlwaysON, Data Compression and concurrency related changes over the past several releases of SQL Server. Experienced in leading development teams both for in-house and offshore engagements. Equally at ease both with drill-down discussions with engineers as well as working with customers and partners. He has authored many technical white papers/blogs, co-authored two books in SQL Server and has presented database technologies in numerous national/international conferences. Sunil enjoys teaching and has taught programming courses at University of Rhode Island and Univers