Scaling SQL for your Peak Database Load

Each SQL Server is different, but all SQL Servers have one thing in common: there are times when the SQL Server needs to scale to meet peak workload of the business. But before the SQL Server can scale, you must determine the capacity and workload health of the SQL Server instance. After reviewing the SQL Server instance and determine you do not have enough capacity and identify 5 chaotic events that would impact the SLAs, what actions do you take to increase the capacity and reduce the chaos? What tools and metrics do you look at to determine the workload health and capacity of the system? In this session, we focus on what information to gather from the key stakeholders and document what success means. Then we focus on how to assess the systems to determine the capacity and workload health of the SQL Server instance using native Windows and SQL Server tools. Once we understand where the SQL Server is today, then we will focus on the process of calculating the future workload requirements and identifying what actions need to be executed to prepare the system for the peak workload.

Feedback link

Starts: 11:20 12th Mar 2022
Ends: 12:10 12th Mar 2022


Short Description
- Scaling SQL Servers is complex and is more relevant today as the transactional and data growth rates continue to grow. In this session, we will talk about what it takes to scale SQL Server to meet the peak workload.


Ben DeBow


AWSAzureOn PremisesFuture DBAOperational DatabasesDeploymentHealth and WellBeingManagingMonitoringOptimisingAzure SQL DatabaseDatabase EngineIn-Memory OLTPManaged InstanceSQL 2019SQL 2022IntermediateHow

The SQL Bits Story

SQLBits was formed in 2007 by a group of volunteers who were passionate about the SQL Server product suite and wanted to provide much-needed community-driven education to the data community.

As one of the largest data platform conferences in the world, we offer more opportunities to a wider audience.

15 Years

We’ve grown and expanded a lot since 2007.

2500 Participants

SQLBits is the best place to meet fellow data professionals.

82 Countries

We welcome data professionals from all over the globe.

1140 recorded sessions

All the live sessions are recorded and offered for free, year round.

Experience the SQLBits Conference


Want to be part of the SQLBits community?

Attend the London conference in-person or virtually on 

March 8-12, 2022 at ExCel London, UK.