Scaling Your SQL Server Application

Scaling Your SQL Server Application

English | MP4 | AVC 1280Ă—720 | AAC 48KHz 2ch | 1h 04m | 123 MB

Can you applications handle the load? In this one-hour class, you can learn about techniques to scale your SQL Server application as both your data volume and userbase grow. Instructor Joey D’Antoni introduces techniques you can use when designing a new application as well as techniques to fix an existing application—balancing security and performance concerns. Learn how to leverage built-in SQL Server features such as columnstore indexing, read-only routing, and portioning, and design a tenancy model that meets the demands of your application. Plus, find out how to use a caching tier and integrate Microsoft Azure for cloud-based storage that automatically scales as your needs grow.

Topics include:

  • Designing for high-write and high-read workloads
  • Designing an archiving model
  • Leveraging SQL features such as portioning and compression
  • Building a tenancy model
  • Using Azure design patterns for scaling
Table of Contents

Introduction
1 Scaling your data tier
2 Tools and techniques
3 Introduction to SQL Server 2017

Designing for Scale
4 Understanding your workload pattern
5 Designing for a high-write workload
6 Designing for a high-read workload
7 Building an archiving model

SQL Server Features That Help Your Application Scale
8 In-memory OLTP overview
9 Columnstore overview
10 Always On availability groups – Read-only routing
11 Partitioning and compression
12 Indexing strategies

Building a Tenancy Model
13 Tenancy models
14 Multitenant app with database per tenant
15 Multitenant app with sharded multitenant databases
16 Database per tenant

Azure Design Patterns for Scale
17 Caching layer
18 Scale-out options in Azure
19 Design anti-patterns

Conclusion
20 Next steps