Introducing Performance Studio Free SQL Server Query Plan Analysis Tool
Summary
In this video, I introduce my latest tool, Performance Studio, which I've been working on and refining for a while now. Performance Studio is a powerful, free tool designed to help SQL Server professionals analyze and optimize their queries more effectively. I walk through some of its key features, including a query editor that allows you to run arbitrary queries against a SQL Server, and an execution plan viewer that provides detailed insights into query performance. I also highlight the integration with SQL Server's Query Store, which helps track and analyze query performance over time. Throughout the video, I demonstrate how Performance Studio surfaces important information like runtime summaries, weight stats, and parallelism effectiveness, making it easier to identify areas for optimization. I encourage viewers to check out the tool on my GitHub repo at code.erikdarling.com and provide feedback to help it continue to evolve.
Chapters
*00:00:00* - Introduction
*00:01:12* - Tool Overview
*00:03:34* - Plan Comparison
*00:05:12* - Parallelism Effectiveness
*00:07:23* - Many-to-Many Merge Join
*00:09:04* - Non-Parallel Plan Reasons
*00:10:52* - Conclusion
━━━━━━━━━━━━━━━━━━━━━━━━━━
🕵️♂️ FREE SQL SERVER MONITORING & Plan Analysis
━━━━━━━━━━━━━━━━━━━━━━━━━━
https://github.com/erikdarlingdata/Pe...
https://github.com/erikdarlingdata/Pe...
━━━━━━━━━━━━━━━━━━━━━━━━━━
📚 TRAINING & COURSES
━━━━━━━━━━━━━━━━━━━━━━━━━━
Get AI-Ready With Erik
https://training.erikdarling.com/get-...
SQL Server Performance Engineering Course
https://training.erikdarling.com/sql-...
Learn T-SQL with Erik
https://training.erikdarling.com/lear...
Everything Bundle:
https://training.erikdarling.com/?cou...
━━━━━━━━━━━━━━━━━━━━━━━━━━
🛠️ CONSULTING & SERVICES
━━━━━━━━━━━━━━━━━━━━━━━━━━
Need SQL Server performance help?
https://training.erikdarling.com/sqlc...
━━━━━━━━━━━━━━━━━━━━━━━━━━
💬 CONNECT
━━━━━━━━━━━━━━━━━━━━━━━━━━
Ask questions at Office Hours
https://erikdarling.com/officehours/
Become a channel member
/ @erikdarlingdata
On this page of the site you can watch the video online Introducing Performance Studio Free SQL Server Query Plan Analysis Tool with a duration of hours minute second in good quality, which was uploaded by the user Erik Darling (Erik Darling Data) 11 March 2026, share the link with friends and acquaintances, this video has already been watched 1,656 times on youtube and it was liked by 105 viewers. Enjoy your viewing!
