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/

Avsnitt(287)

Episode 135: Seinfeld Episode

Episode 135: Seinfeld Episode

Normally we have one specific topic we focus on each episode.  This episode is a little different. The show notes for today's episode can be found at http://sqldatapartners.com/2018/05/16/episode-135-...

16 Maj 201819min

Episode 134: CosmosDB

Episode 134: CosmosDB

It is not very often the internal codename is used when a product is launched; however, when you think about a database designed with global distribution in mind, CosmosDB makes sense.  I was a bit sh...

9 Maj 201849min

Episode 133: Shrinking Files

Episode 133: Shrinking Files

While the ability to shrink data files is available in SSMS, the conventional wisdom is don't do it.  I was extremely curious when I read an email from our guest suggesting the opposite.  In this epis...

3 Maj 201835min

Episode 132: What technologists can learn from superheroes

Episode 132: What technologists can learn from superheroes

Bang! Pow! Crash!  Besides just awesome fighting techniques, are there things we can learn from superheroes?  My guest, Will Fehringer, gave that very question some thought and came up with some very ...

19 Apr 201828min

Episode 131: Big Data Solutions in the Cloud

Episode 131: Big Data Solutions in the Cloud

Big Data.  Do you have big data?  What does that even mean?  In this episode I explore some of the concepts of how organizations can manage their data and what questions you might need to ask before y...

11 Apr 201845min

Episode 130: Use Case for PowerShell

Episode 130: Use Case for PowerShell

Heroes in a half shell, PowerShell!  Well, maybe that wasn't the original line, but you know from this program and other places on the internet, PowerShell is all the rage.  In this episode, we wanted...

4 Apr 201831min

Episode 129: Graph Databases

Episode 129: Graph Databases

Books online state: "There is nothing a graph database can achieve, which cannot be achieved using a relational database." Why then are we putting graph technology in SQL Server? To help me answer th...

28 Mars 201832min

Episode 128: Database Doing DevOps

Episode 128: Database Doing DevOps

To Devops or not to Devops, that is the question. We've talked before about how the developers have all the cool new tools, but this is slowly changing. For those in development or dare I say agile ...

21 Mars 201842min

Populärt inom Utbildning

historiepodden-se
rss-bara-en-till-om-missbruk-medberoende-2
det-skaver
harrisons-dramatiska-historia
nu-blir-det-historia
rss-viktmedicinpodden
johannes-hansen-podcast
not-fanny-anymore
roda-vita-rosen
rss-foraldramotet-bring-lagercrantz
sektledare
allt-du-velat-veta
i-vantan-pa-katastrofen
sa-in-i-sjalen
rss-sjalsligt-avkladd
sex-pa-riktigt-med-marika-smith
rss-basta-livet
rikatillsammans-om-privatekonomi-rikedom-i-livet
rss-pa-insidan-med-bjorn-rudman
rss-traningsklubben