[ Live Webinar on July 16, 2025 at 1 pm EDT - 10 am PDT ]
Getting Started with SQL Server Performance Tuning
Have you ever found yourself in need to identify why performance went bad? How about making queries go faster but didn't know where to begin?
In this session, you will learn:
Multiple ways to find your top offending statements.
Identify the root of a blocking chain
You will learn three key tips to help you understand execution plans.
A framework to help you create indexes to help performance.
We will cover:
Using Query Store - The free performance monitoring tool built-in SQL Server
Dynamic Management Views (DMVs) - Read system health meta data
Execution Plans - The flight path of SQL Server getting your data when you execute queries
Indexing Basics - How to search and find data vs scanning and reading every page
Speaker
— Kon Melamud
CTO of Procure SQL
Chief Technology Officer at Procure SQL. With 20+ years of experience, he offers innovative strategies to achieve your business goals. Outside work, Kon enjoys tinkering on his vehicles..
Improving your PERFORMANCE is easier than you think
In one hour, we will cover three very important tools included with SQL Server to help make your queries go faster!
Query Store & DMVs
Stop wasting time guessing which queries are your bottleneck. With DMVs and Query Store we will be able to identify current problems and problems that occurred in the past.
EXECUTION PLANS
Execution plans is your flight plan towards getting your your data once you run your query. We will identify three key mistakes and show you how to fix them.
INDEXING FRAMEWORK
You will learn a 12 step framework that will help beginners apply the best index to make their queries go at least 10 times faster than scanning the whole tables.