When pushing the database engine to its limits there are "Usual suspects" in terms of the bottlenecks that the database engine will always hit. In particular there is one "Anti-pattern" that always plagues any system that involves the processing of OLTP like workloads. That is synchronization between threads around structures and primitives that ensure ACID compliance. This session will not only explore this, but cover an innovative approach to solving this conundrum which involves containers and sharding.
Chris has been working on the SQL Server since 2000 in various roles including DBA, developer and architect, he has been a regular speaker at various events in Europe for the last five years or so, including SQL Bits. Chris currently works at Pure Storage as the SQL Server Solutions Architect for EMEA.