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!

Jaksot(287)

Episode 215: Azure Data Factory

Episode 215: Azure Data Factory

We have been moving data for years with technologies like DTS and SSIS; however, these were very much designed for on-premises moves in mind. As more cloud services were being offered Microsoft needed...

27 Tammi 20211h 7min

Episode 213: New Goals for 2021

Episode 213: New Goals for 2021

We open this year with a few updates on the podcast, a change to SQL Trail, and we invite you to give us some feedback on writing a book for 2021. The show notes for today's episode can be found at ht...

13 Tammi 202132min

Episode 212: 10 Things You Need to Know About Data Security

Episode 212: 10 Things You Need to Know About Data Security

20 years ago, the objection to implementing security on the basis of performance had validity—especially for smaller organizations. Security was a pain in the neck; however, how many of us are still h...

31 Joulu 202059min

Episode 211: Solorigate

Episode 211: Solorigate

Microsoft released a lengthy white paper on the SolarWinds hack affecting thousands of computers. This is scary stuff, and the details continue to come out slowly and you wonder how it all will play o...

23 Joulu 202046min

Episode 210: The Elephant in the Room

Episode 210: The Elephant in the Room

It was sad news to hear PASS plans to dissolve in January of 2021. So much good has come of the community and it is sad to see it go. In this episode, we explore the why behind the collapse and what w...

18 Joulu 202052min

Episode 209: Career Ready: Advice to New Graduates

Episode 209: Career Ready: Advice to New Graduates

Finding your first full time job is incredibly difficult—and that was before we were in a worldwide pandemic. In this episode, we discuss some strategies and share some experiences about how we got ou...

14 Joulu 202050min

Episode 208: SQL Server and Graph Data

Episode 208: SQL Server and Graph Data

There is a growing list of formats to store data and Graph is one of the newer trends. It is becoming so popular SQL Server has created ways to implement graph structures. Mala Mahadevan joins us in t...

28 Loka 202032min

Episode 207: SQL Trail 2020 Retrospective

Episode 207: SQL Trail 2020 Retrospective

SQL Trail 2020 was a success! There was a time I was unconvinced this would be the case. This is not to say we didn't have issues; however, talking with others helped us avoid some common pitfalls and...

15 Loka 202025min

Suosittua kategoriassa Koulutus

rss-murhan-anatomia
voi-hyvin-meditaatiot-2
psykopodiaa-podcast
rss-narsisti
adhd-podi
rahapuhetta
rss-rahamania
kesken
psykologia
rss-liian-kuuma-peruna
rss-niinku-asia-on
rss-eron-alkemiaa
rss-arkea-ja-aurinkoa-podcast-espanjasta
esa-saarinen-filosofia-ja-systeemiajattelu
rss-duodecim-lehti
rss-vapaudu-voimaasi
rss-luonnollinen-synnytys-podcast
rss-tietoinen-yhteys-podcast-2
rss-finnish-daily-dialogues
ihminen-tavattavissa-tommy-hellsten-instituutti