Real-World Case Study: Push Your App to Enterprise Scale with Advanced SQL Server Features


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.

Interested in additional SentryOne webinars?  Check our webinar library.

Available On Demand

Kevin Kline

Kevin Kline

Principal Program Manager

Kevin (@kekline) is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a renowned database expert, software industry veteran, Microsoft MVP, Google Author, and long-time blogger at sqlblog.com and at kevinekline.com. Currently, Kevin is responsible for SentryOne's technical sales and marketing initiatives and is also heavily involved in product design activities.

Melissa Connors

Melissa Connors

Senior Techincal Writer

Melissa (@MelikaNoKaOi) is the Senior Technical Writer/Special Projects Lead at SentryOne, where she focuses primarily on technical writing, performance testing, and analysis of the SentryOne platform as well as its integration with other technologies, such as the latest SQL Server features. Melissa has over a decade of experience with SQL Server through software performance testing, research projects, application development, and technical support.

Andy Mallon

Andy Mallon

Product Manager

Andy (@AMtwo) is a SQL Server DBA and Microsoft Data Platform MVP that has managed databases in the healthcare, finance, e-commerce, and non-profit sectors. Since 2003, he has been supporting high-volume, highly-available OLTP environments with demanding performance needs. He is a founder of BostonSQL, co-organizer of SQL Saturday Boston, and speaker at many SQL Server user groups and SQLSaturdays.

Rob Sewell

Rob Sewell

Sewell Consulting, SentryOne PAC Ambassador

Rob (@SQLDBAwithaBeard) is a SQL Server DBA with a passion for PowerShell, Azure, Automation, and SQL (PaaS, geddit?). He is an MVP and an officer for the PASS PowerShell VG and has spoken and volunteered at many events.

He is a member of the committee that organizes SQLSaturday Exeter and also the European PowerShell Conference. He is a proud supporter of the SQL and PowerShell communities. Rob is also a member of the SentryOne PAC.

He relishes sharing and learning and can be found doing both via Twitter and his blog. He also has a fabulous beard!

Companies with the highest demands for database performance choose SentryOne