You have an OLTP database application that sustains a heavy mixed workload with lots of read and write transactions; at the same time, a client application reports on the data. Performance was fine for a long time, but it is not meeting your needs now that it must scale to much higher workloads. What should you do?
In this real-world case study, you’ll learn about a series of technologies that provide unprecedented scalability, including data compression, In-Memory OLTP, and partitioned clustered columnstore indexes (CCI). We will walk you through a chronology of the application and database architecture, its changes over time, and the degree of performance improvement achieved with each new SQL Server feature applied.
Here’s a snapshot of what you can expect in this session:
- A quick review of the fundamentals for building a highly scalable application and database.
- Learn how to plan, prepare for, and implement advanced features on SQL Server, including data compression, In-Memory OLTP, and partitioned CCI.
- Discover the performance impact of each of the major feature implementations as they relieve performance bottlenecks.
- Identify the trade-offs in applying major new features, tips and tricks, and other advice for achieving enterprise scale in your SQL Server applications.