Tech·Ed North America 2010

Strategies to Get Maximum Concurrency for Your Workload in Microsoft SQL Server

Download this episode

Download Video

Description

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.
For more information, check out this course on Microsoft Virtual Academy:

Day:

3

Code:

DAT315

Embed

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.