- SQL 2012 OLTP Improvements
Description:
SQL Server 2012 provides enhancements to internal components and programmability features in the relational engine. In this session we'll focus on common challenges our OLTP workloads face:
· Describe how new features can benefit and how they relate to older functionality.
· We will look at what you should consider for use as you design a system, maintain it and troubleshoot it
· We will look at how programmability enhancements like query paging can be used
· How Sequence objects can be leveraged to unblock latch contention scenarios
· The internal enhancements we have made to the memory manager and what you need to know about it
· Walk through practical examples of how to use the new XEventsUI and harness it's debugging capabilities so that you can get a real insight into what is going on in your system.
The session expects you to have some basic knowledge about OLTP architecture, SQL Server B-tree indexes and data modeling.
Go to top