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 231: Mental Health and Wellness in IT

Episode 231: Mental Health and Wellness in IT

Everyone has bad days; however, how those bad days develop are unique to each of us. In a special episode, we chat with Tracy Boggiano about her experiences with Mental Health, how she has dealt with ...

11 Aug 202159min

Episode 230: RTO & RPO

Episode 230: RTO & RPO

No one wants to lose data when disaster strikes; however, we need to plan for some data loss and putting all the pieces in place can be tricky. There are two metrics commonly used to measure data loss...

4 Aug 202141min

Episode 229: Data Migration Assistant

Episode 229: Data Migration Assistant

The scary part of upgrading SQL Server is finding out you have a problem AFTER the fact. In this episode, Mariano Kovo joins us to discuss the Data Migration Assistant tool from Microsoft. While the n...

21 Jul 202143min

Episode 228: Predicting Application Problems with Database Metrics

Episode 228: Predicting Application Problems with Database Metrics

As data practitioners, we want to get ahead of any problems that might come up and share those insights with others on our team. In this episode, Edward Pollack gives us a few scenarios we might consi...

14 Jul 20211h 7min

Episode 227: SSDT Methodologies for DB DevOps

Episode 227: SSDT Methodologies for DB DevOps

Organizations look to constantly improve and offer better services and the application tooling has been built to accommodate the process. Database tooling has been a bit slower to develop; however, in...

23 Jun 20211h 9min

Episode 226: SQL Server IaaS Agent Extension

Episode 226: SQL Server IaaS Agent Extension

Let's say you have completed a lift and shift VM hosting to the cloud. Great—you now use Iaas services. While you don't have to worry about the hardware, managing the software can be problematic. T...

9 Jun 202158min

Episode 225: Dashboard Design Principles

Episode 225: Dashboard Design Principles

Have you ever created a report in a visualization tool, spent all this time and energy creating something that looked really cool, went through more edits than you could remember only to deliver the r...

26 Mai 202156min

Episode 224: The Standup Meeting

Episode 224: The Standup Meeting

Carlos, Kevin, and Eugene reconnect after some time away with a new streaming time.  Long form conversation on a single topic is also the place we want to get back to in our podcast.  The show notes a...

28 Apr 202124min

Populært innen Fakta

fastlegen
dine-penger-pengeradet
relasjonspodden-med-dora-thorhallsdottir-kjersti-idem
rss-strid-de-norske-borgerkrigene
foreldreradet
treningspodden
rss-sunn-okonomi
jakt-og-fiskepodden
takk-og-lov-med-anine-kierulf
sinnsyn
merry-quizmas
gravid-uke-for-uke
rss-kunsten-a-leve
rss-kull
hagespiren-podcast
hverdagspsyken
rss-var-forste-kaffe
fryktlos
rss-mann-i-krise-med-sagen
smart-forklart