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 135: Seinfeld Episode
Episode 134: CosmosDB
Episode 133: Shrinking Files
Episode 132: What technologists can learn from superheroes
Episode 131: Big Data Solutions in the Cloud
Episode 130: Use Case for PowerShell
Episode 129: Graph Databases
Episode 128: Database Doing DevOps
Episode 127: Developing in the database
Episode 126: SQLSaturday Edition
Episode 125: You must be an engineer
Episode 124: Beyond the runbook; DR Organization
Episode 123: Top 5 things to know when getting admin access
Episode 122: Isolation Levels
Episode 121: What makes a good manager?
Episode 120: SQL Injection
Episode 119: Getting started with GitHub
Episode 118: How has index maintenance changed?
Episode 117: PASS Summit Retrospective
Episode 116: Are people still using PSSDiag?
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