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 247: Pushing the Boundaries or Pushing Your Luck

Episode 247: Pushing the Boundaries or Pushing Your Luck

IT workers will generally claim they like learning new technology—it is almost a required attribute.  Why then is bringing in new technology so hard?  In this episode, we explore how new technologies ...

15 Kesä 202235min

Episode 246: Microsoft Build 2022 Announcements

Episode 246: Microsoft Build 2022 Announcements

While we continue to review the new features of the CTP preview of SQL Server 2022, we turn our attention to the recent Microsoft Build conference and talk about some of the announcements made. We tr...

8 Kesä 202229min

Episode 245: Tooling Updates

Episode 245: Tooling Updates

SQL Server Management Studio (SSMS) version 18 was introduced to support SQL Server 2019 and in this episode of the podcast, we discuss some of the new updates available in SSMS and Azure Data Studio....

20 Huhti 202239min

Episode 244: Extended Events vs SQL Server Audit

Episode 244: Extended Events vs SQL Server Audit

Who made that change?  It is one of those questions that can send chills down the spine of those responsible for databases.  In this episode, Josephine Bush talks with us about how we can use a combin...

30 Maalis 20221h 6min

Episode 243: Choosing What Content To Focus On

Episode 243: Choosing What Content To Focus On

Conferences are on the uptick as COVID restrictions lift and we are excited for the upcoming year. After Eugene's return from SQLBits my thoughts revolved around what I wanted to learn this year at co...

16 Maalis 202242min

Episode 242: Upgrading Your SQL Server

Episode 242: Upgrading Your SQL Server

SQL Server 2012 is end of life later this year. I feel too young for this to be happening—it seems like only last year SQL Server 2005 came out. In this episode of the podcast, we talk about upgradi...

2 Helmi 202250min

Episode 241: Replicating Data with Azure SQL Data Sync

Episode 241: Replicating Data with Azure SQL Data Sync

Do you find you need to keep SQL Server tables in sync across multiple systems?  After several projects involving syncing data, we return to the topic of Azure SQL Data Sync with some real world examp...

20 Tammi 202238min

Episode 240: Azure Synapse Link

Episode 240: Azure Synapse Link

Azure Synapse Link is a feature coming to SQL Server in the next release. While there are few details on what the new feature will look like, we discuss how this same service is implemented in other A...

5 Tammi 202234min

Suosittua kategoriassa Koulutus

rss-murhan-anatomia
psykopodiaa-podcast
voi-hyvin-meditaatiot-2
rss-valo-minussa-2
rss-niinku-asia-on
aamukahvilla
rss-narsisti
adhd-podi
rss-duodecim-lehti
rahapuhetta
aloita-meditaatio
kesken
rss-elamankoulu
koulu-podcast-2
salainen-paivakirja
rss-uskonto-on-tylsaa
rss-liian-kuuma-peruna
rss-luonnollinen-synnytys-podcast
rss-koira-haudattuna
rss-hereilla