SQL Server normally relies on concurrency models in order to
maintain the Isolation in ACID. As systems scale, this method can go from being
a benefit to a hindrance, limiting the concurrency for our applications and
Throwing hardware at the problem can help, but does not
address the fundamental issues. These can only be resolved with better database
design and the correct configurations.
Join John as we work through the different design patterns
that exist for increasing concurrency. From using specific data types, and
partitioning, to how In-Memory OLTP can help. By the end of this season you
will understand the different methods available to boost concurrency regardless
of the size of your environment.