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
Sur cette page du site, vous pouvez voir la vidéo en ligne Introducing Performance Studio Free SQL Server Query Plan Analysis Tool durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Erik Darling (Erik Darling Data) 11 mars 2026, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 1,656 fois et il a aimé 105 téléspectateurs. Bon visionnage!
