In this session, we will explore the intricacies of optimizing performance in SQL Server and Azure SQL. We will start with an in-depth look at hardware and cloud resources, covering CPU, Memory, IOPs/JBODS, and Networking. Next, we will delve into understanding query performance by examining the SQL Query Optimizer, locking, blocking, indexing, and recovery models. We will also discuss how to size workloads, planning for both low-use and high-capacity systems, and gather metrics to project IOPs, Memory, and CPU utilization. Finally, we will cover scaling workloads through replication, AlwaysOn, and Microsoft Fabric Mirroring.

Hardware / How the Cloud works:

• CPU
• Memory
• IOPs / JBODs
• Networking

Understanding Query Performance:

• Review how the Query Optimizer works
• Locking
• Blocking
• Indexing
• Recovery Models

Sizing Workloads:

• Planning for low use to high-capacity system
• Gathering metrics to project IOPs, Memory, & CPU Utilization

Scaling Workloads via:

• Replication
• AlwaysOn
• Microsoft Fabric Mirroring

You will learn:

• Understand Cloud storage access patterns
• Understand query performance tuning
• Understand how to maximize performance