Episode 23: IO, IO, It's Off to Tune We Go

Episode 23: IO, IO, It's Off to Tune We Go

If I were a betting man, I would wager your disk IO system is probably the biggest bottleneck in your SQL Server right now. Sure, there are lots of moving pieces, but if you can tame the IO situation, you are putting yourself in the drivers seat. So how do you go about putting together the pieces you need identify your IO constraints?

I chat with Theresa Iserman, a premier support engineer at Microsoft about some of her thoughts and why IO in general is an issue. She gives us some guidelines and even some metrics to check out. Join us in the conversation, and I'll see you on the SQL trail . . .

As always you can check out the show notes at http://sqldatapartners.com/2015/12/22/iotuning/

Jaksot(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 Elo 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 Elo 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 Heinä 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 Heinä 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 Kesä 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 Kesä 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 Touko 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 Huhti 202124min

Suosittua kategoriassa Koulutus

rss-murhan-anatomia
psykopodiaa-podcast
voi-hyvin-meditaatiot-2
rss-niinku-asia-on
kesken
rss-liian-kuuma-peruna
rss-narsisti
adhd-podi
psykologia
rss-duodecim-lehti
ihminen-tavattavissa-tommy-hellsten-instituutti
rss-psykalab
aamukahvilla
aloita-meditaatio
rss-honest-talk-with-laurrenna
rss-luonnollinen-synnytys-podcast
rss-tietoinen-yhteys-podcast-2
rahapuhetta
puhutaan-koiraa
rss-elamankoulu