22-25 April 2026 
Workload Analysis Made Super Easy: PowerShell and WorkloadTools
Proposed session for SQLBits 2026TL; DR
Learn how to automate SQL Server workload analysis with PowerShell and WorkloadTools. Streamline configuration, capture, and reporting to save time, simplify performance tuning, and gain actionable insights for optimization.
Session Details
This session is designed for DBAs and data professionals who need to analyze SQL Server workloads efficiently without getting lost in complexity. Workload analysis often feels overwhelming—manual configuration, time-consuming processes, and inconsistent results can slow you down.
In this presentation, you’ll learn how to eliminate those pain points by automating workload analysis with PowerShell and WorkloadTools. I’ll show you how to streamline configuration and execution, enabling you to collect, analyze, and interpret workload data with minimal effort.
By the end, you’ll walk away with practical scripts and techniques to simplify workload analysis, save hours of manual work, and gain actionable insights to optimize database performance.
In this presentation, you’ll learn how to eliminate those pain points by automating workload analysis with PowerShell and WorkloadTools. I’ll show you how to streamline configuration and execution, enabling you to collect, analyze, and interpret workload data with minimal effort.
By the end, you’ll walk away with practical scripts and techniques to simplify workload analysis, save hours of manual work, and gain actionable insights to optimize database performance.
3 things you'll get out of this session
- Learn to Automate Workload Analysis Setup
- Learn to Streamline Data Collection and Analysis
- Learn to Apply Insights for Optimization
Speakers
Tracy Boggiano's other proposed sessions for 2026
Heroes of Compliance: Mastering SQL Audit and Extended Events - 2026
Leveraging Data for Mental Health - 2026
The Hero’s Journey: Mastering Your New DBA Role - 2026
The Superhero's Handbook for SQL Server Error Handling - 2026
Tracy Boggiano's previous sessions
How Leaders Can Support Their Employee’s Mental Health
Sometimes as leaders it's hard to know how to address the topic of of a an employee's mental health. Come to this session for come practical, straightforward strategies to be used to address a very difficult topic.
How To Get the Auditors Off Your Butt with dbachecks
Auditors are not fun to deal with and proving your systems meet requirements is a PITA. Come to this session to learn how to leverage dbachecks to check your SQL Servers for security compliance.