Do you find yourself repeating the same actions when pulling SQL Server performance metrics?
Performance tuning a troublesome SQL Server can be a challenge. Luckily the community continues to produce wonderful folks like Erik Darling who contribute their knowledge to make your life a bit easier. In this episode of the SQL Data Partners podcast, we sit down with Erik and discuss the scripts he built to gather performance metrics. While every potential issue is not captured in these scripts, they'll help you start gathering information so you can decide on the next step to take.
Get the scripts: code.erikdarling.com
Have you used Erik’s scripts before? Let us know!
The show notes for today's episode can be found at Episode 272: Performance Tuning Scripts. Have fun on the SQL Trail!
Episode 194: PolyBase Use Cases
Episode 193: Power BI Premium
Episode 192: The DBA is Dead! Long Live the DBA!
Episode 191: Power BI Row-Level Security
Episode 190: SQL Server 2019
Episode 189: Power BI Common Data Model
Episode 188: Databricks
Episode 187: Power BI Performance Tuning
Episode 186: Analytics & Security: Find Pain Points, Make a Plan
Episode 185: DBATools in a Month of Lunches
Episode 184: Where do people get stuck with Power BI?
Episode 183: SQL Server Big Data Clusters
Episode 182: XEvents
Episode 181: Paginated Reports in Power BI
Episode 180: PolyBase in SQL Server 2019
Episode 179: SQL Trail Recap & Buying Power BI
Episode 178: Database Design
Episode 177: Lock Pages in Memory
Episode 176: Power BI Storage Options
Episode 175: Migrating to the Cloud
Create your
podcast in
minutes
It is Free
Insight Story: Tech Trends Unpacked
Zero-Shot
Fast Forward by Tomorrow Unlocked: Tech past, tech future
The Unbelivable Truth - Series 1 - 26 including specials and pilot
A Prairie Home Companion: News from Lake Wobegon