 |
 |
 |
Premier Sponsor:
Platinum Sponsor:
Locking and Blocking and Versions, Oh My
Failing to design an application with concurrency in mind, and failure to test an application with the maximum number of expected simultaneous users is one of the main causes of poor application performance.
SQL Server offers two methods for an application to provide data consistency: Pessimistic and Optimistic Concurrency Control. In this seminar we’ll discuss what consistency might mean to your applications, and describe the details of how each of the concurrency models works internally. We’ll examine the costs and trade-offs between the two concurrency models that SQL Server 2008 supports through different transaction isolation levels. Finally, we’ll examine the tools available for analyzing and troubleshooting locking problems, including metadata views and the Management Data Warehouse.
Want to get a preview of this all-day seminar? Get a one-hour taste at Kalen Delaney's "Isolation vs Concurrency: What Are the Choices?" online webinar at 24 Hours of PASS.
SQL Server offers two methods for an application to provide data consistency: Pessimistic and Optimistic Concurrency Control. In this seminar we’ll discuss what consistency might mean to your applications, and describe the details of how each of the concurrency models works internally. We’ll examine the costs and trade-offs between the two concurrency models that SQL Server 2008 supports through different transaction isolation levels. Finally, we’ll examine the tools available for analyzing and troubleshooting locking problems, including metadata views and the Management Data Warehouse.
Want to get a preview of this all-day seminar? Get a one-hour taste at Kalen Delaney's "Isolation vs Concurrency: What Are the Choices?" online webinar at 24 Hours of PASS.
Read Q&A blog on this session.
Speaker:
SQLearning
Kalen Delaney has been working with SQL Server for 23 years, and provides advanced SQL Server training to clients around the world, using her own custom-developed curriculum. She has been a SQL Server MVP since 1993 and has been writing about SQL Server almost as long. Kalen has spoken at dozens of technical conferences, including every PASS conference in the US, since the organization’s founding in 1999. Kalen is a contributing editor and columnist for SQL Server Magazine and the author or co-author of several of the most deeply technical books on SQL Server, the most recent being SQL Server 2008 Internals, from Microsoft Press. Kalen blogs at www.sqlblog.com and her personal website and schedule can be found at www.SQLServerInternals.com.
Register Now for PASS Summit 2010!
 |
 |
|
|
Top Reasons to Attend PASS Summit 2010
|
||
 |
 |
Gold Sponsor |
||||||
|
