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 https://sqlb.it/?6995
Starts: 11:20 12th Mar 2022
Ends: 12:10 12th Mar 2022
- 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.
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.
We’ve grown and expanded a lot since 2007.
SQLBits is the best place to meet fellow data professionals.
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