The DBA Fundamentals VG offers training and support to individuals interested in a solid DBA foundation.

Event Display
Meeting Detail

Tue, Nov 21 2017 02:30 UTC


Strategies to get maximum concurrency for your workload in SQL Server - Redo

RSVP: None

Strategies to get maximum concurrency for your workload in SQL Server - Redo

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 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

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