Identifying and Optimizing Heavy Hitters in SQL Server

Sometimes, a handful of queries or processes consume disproportionate resources, affecting overall performance. This session focuses on identifying these top resource consumers within your SQL Server environment.

Pinal Dave will demonstrate tools and techniques to monitor resource usage, analyze workload patterns and prioritize optimization efforts where they matter most.

You’ll learn how to address these heavy hitters through indexing, query tuning or hardware considerations. By the end of this session, you’ll be equipped to make impactful improvements that enhance SQL Server performance across the board.

Speaker bio:

Pinal Dave is a SQL Server performance tuning expert and independent consultant with more than 22 years of hands-on experience. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,700 database tech articles on his blog.