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 255: Automate Complex CRUD with sp_CRUDGen
Episode 254: Code Smell Checks with sp_Develop
Episode 253: Go Mobile with Power Apps
Episode 252: The Cumulative Update Dilemma
Episode 251: Azure Cognitive Services
Episode 250: What happens before... “COMPANEROS!”
Episode 249: Data Marts in Power BI
Episode 248: Inventory Documentation
Episode 247: Pushing the Boundaries or Pushing Your Luck
Episode 246: Microsoft Build 2022 Announcements
Episode 245: Tooling Updates
Episode 244: Extended Events vs SQL Server Audit
Episode 243: Choosing What Content To Focus On
Episode 242: Upgrading Your SQL Server
Episode 241: Replicating Data with Azure SQL Data Sync
Episode 240: Azure Synapse Link
Episode 239: Bi-directional HA/DR to Azure SQL
Episode 238: Getting Started with Power BI - Part 2
Episode 237: Getting Started with Power BI - Part 1
Episode 236: Database Monitoring with SQL Sentry
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