July 17, 2018 – Real-World Case Study: Push Your App to Enterprise Scale with Advanced SQL Server Features

Real-World Case Study:

Push Your App to Enterprise Scale with Advanced SQL Server Features

July 17, 2018, 6:00pm

Kevin Kline

You have an OLTP database application which sustains a heavy mixed workload with lots of read and write transactions at the same time that it reports data base to a client application. 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 clustered-partitioned columnstore indexes. 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. This session will teach you all about planning and implementing advanced SQL Server performance features and how each one impacts your system performance for applications with 100’s or 1000’s of concurrent users. Here’s what you’ll learn in this session:

  • Learn how to plan, prepare for, and implement advanced features on SQL Servers, including data compression, In-Memory OLTP, and clustered-partitioned columnstore indexes.
  • See the performance impact of each of the major feature implementations as they relieve performance bottlenecks.
  • Learn about the trade-offs in applying major new features, tips and tricks, and other advice for achieving enterprise scale in your SQL Server applications.

Speaker Bio

Kevin Kline is a database expert and Principal Program Manager at SentryOne, the industry leading SQL Server database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS. Kevin is an author of many books, blogger, columnist, and popular international speaker. Kevin’s best known book is the best-selling SQL in a Nutshell and contributes monthly to Database Trends & Applications magazine. He tweets at @kekline and blogs at http://Blogs.SQLSentry.com/Authors/KevinKline.

Important meeting information:

We meet at the offices of Wayfair, upstairs from the Copley Place Mall, at 4 Copley Place, Boston.

Due to building security at our meeting venue, attendees must be registered, and must present a valid photo ID to building security. Directions to the Wayfair offices can be found here.

Typical Meeting Format:

6:00pm – 6:30pm — food / beverages, networking and group discussion

6:30pm – 6:45pm — news, announcements, upcoming training opportunities

6:45pm – 8:15pm — guest speaker presentation

Sponsored by