Strategies to Get Maximum Concurrency for Your Workload in Microsoft SQL Server
Play Strategies to Get Maximum Concurrency for Your Workload in Microsoft SQL Server
Have you experienced slow-down in your application because of blocking and wondered what you can do? This session covers the basics of concurrency starting with isolation levels including RCSI and snapshot isolation levels, lock escalation, locking granularity, and deadlocks. We follow this with diagnosing and troubleshooting the blocking issues and conclude with general guidelines in designing application(s) for maximum concurrency.