Episode 272: Performance Tuning Scripts

Episode 272: Performance Tuning Scripts

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

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!

Episoder(287)

Episode 239: Bi-directional HA/DR to Azure SQL

Episode 239: Bi-directional HA/DR to Azure SQL

SQL Server 2022 has been announced and we are excited to start unpacking the new features. For this episode, we start with a very interesting feature--Bi-directional HA/DR to Azure SQL. We have the ab...

15 Des 202134min

Episode 238: Getting Started with Power BI - Part 2

Episode 238: Getting Started with Power BI - Part 2

Part 2 Power BI has been described as a "self-service" BI platform. While that may bring to mind an image of easy-peasy, plug-and-play, there are a few things most organizations will want to address b...

8 Des 202131min

Episode 237: Getting Started with Power BI - Part 1

Episode 237: Getting Started with Power BI - Part 1

Part 1 Power BI has been described as a "self-service" BI platform. While that may bring to mind an image of easy-peasy, plug-and-play, there are a few things most organizations will want to address b...

1 Des 20211h 6min

Episode 236: Database Monitoring with SQL Sentry

Episode 236: Database Monitoring with SQL Sentry

Building your own scripts to monitor SQL Server seems like a very reasonable thing to do. We're smart folks and SQL Server is what we do for a living—we should be able to figure this out. Upon further...

17 Nov 202142min

Episode 235: SQL Trail 2021 In-person Q&A

Episode 235: SQL Trail 2021 In-person Q&A

Live Podcast! We decided it was time to try and get together in person and reconnect. As we did, we pulled out the microphone and started recording. As a result, we break the single topic mode this we...

3 Nov 202125min

Episode 234: Communication Tips for the IT Pro

Episode 234: Communication Tips for the IT Pro

As a data pro, you are negotiating and problem-solving all the time, often without knowing it. Your success as a professional as your company evolves its Data Platform depends on how well you can comm...

7 Okt 20211h 1min

Episode 233: ScriptDOM

Episode 233: ScriptDOM

Never heard of ScriptDOM? Neither had we…okay, except Kevin, who obviously knows all. Apparently, the documentation is scarce. Mala Mahadevan uses it, loves it, and graciously offered to come back to ...

15 Sep 202146min

Episode 232: Giving Technical Presentations

Episode 232: Giving Technical Presentations

Public speaking is not fun for most; however, it can be very rewarding. Chris Seferlis chats with us about a few tips he has on being a speaker. Most of the tactical advice we defer to a toastmasters ...

1 Sep 202154min

Populært innen Fakta

fastlegen
dine-penger-pengeradet
relasjonspodden-med-dora-thorhallsdottir-kjersti-idem
treningspodden
foreldreradet
rss-strid-de-norske-borgerkrigene
jakt-og-fiskepodden
rss-sunn-okonomi
takk-og-lov-med-anine-kierulf
merry-quizmas
sinnsyn
rss-kunsten-a-leve
lederskap-nhhs-podkast-om-ledelse
gravid-uke-for-uke
smart-forklart
hverdagspsyken
level-up-med-anniken-binz
hagespiren-podcast
fryktlos
rss-kull