Scaling Your SQL Server Application

Want high-performance applications? Scale your data tier. Learn how to architect SQL Server applications that tolerate heavy workloads and large numbers of users.

Introduction

• Scaling your data tier
• Tools and techniques
• Introduction to SQL Server 2017

1. Designing for Scale

• Understanding your workload pattern
• Designing for a high-write workload
• Designing for a high-read workload
• Building an archiving model

2. SQL Server Features That Help Your Application Scale

• In-memory OLTP overview
• Columnstore overview
• Always On availability groups: Read-only routing
• Partitioning and compression
• Indexing strategies

3. Building a Tenancy Model

• Tenancy models
• Multitenant app with database per tenant
• Multitenant app with sharded multitenant databases
• Database per tenant

4. Azure Design Patterns for Scale

• Caching layer
• Scale-out options in Azure
• Design anti-patterns

Conclusion

• Next steps