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 255: Automate Complex CRUD with sp_CRUDGen

Episode 255: Automate Complex CRUD with sp_CRUDGen

One of the biggest challenges with developers using object-relational mapping (ORM) tools is the bad queries or procedures they create. Sure, most tools can create CRUD (Create, Read, Update, Delete, ...

5 Okt 202228min

Episode 254: Code Smell Checks with sp_Develop

Episode 254: Code Smell Checks with sp_Develop

Would you be interested in a tool to help you do code review checks and provide developers guidance on best practices? In this episode of the SQL Data Partners Podcast, we talk with Kevin Martin, the ...

21 Sep 202229min

Episode 253: Go Mobile with Power Apps

Episode 253: Go Mobile with Power Apps

In this episode, we dive into the Power Apps offering and discuss the pros and cons of using this latest Microsoft offering. Some definitions are given and hopefully this episode can orient folks on h...

7 Sep 202235min

Episode 252: The Cumulative Update Dilemma

Episode 252: The Cumulative Update Dilemma

Knowing your SQL Server is patched when an issue occurs is worth the effort of keeping it patched. While I don't suggest a zero-day install for most folks, setting up a regular cadence to check is a r...

24 Aug 202229min

Episode 251: Azure Cognitive Services

Episode 251: Azure Cognitive Services

How can you begin to integrate AI models into your environment without spending months building everything out? As we continue our march to Episode 256, we bring back our friend Sam Nasr to talk about...

10 Aug 202241min

Episode 250: What happens before... "COMPANEROS!"

Episode 250: What happens before... "COMPANEROS!"

This episode we are doing a bit of a look back and are going to air some previously buried content. Some of the bloopers are pre-video and some of them have some physical comedy, which you'll have to...

27 Juli 202219min

Episode 249: Data Marts in Power BI

Episode 249: Data Marts in Power BI

Data marts in Power BI have arrived and the words "data mart" mean something to data professionals. In this episode of the SQL Data Partners Podcast, we introduce the latest offering in Power BI and ...

13 Juli 202227min

Episode 248: Inventory Documentation

Episode 248: Inventory Documentation

How do you keep records of your SQL Server environments? Patching levels, security accounts, configuration options, maintenance jobs and the like are some of the pieces we have to keep organized. Ar...

29 Juni 20221h 1min

Populärt inom Utbildning

rss-bara-en-till-om-missbruk-medberoende-2
historiepodden-se
det-skaver
alska-oss
nu-blir-det-historia
allt-du-velat-veta
harrisons-dramatiska-historia
johannes-hansen-podcast
not-fanny-anymore
sektledare
rss-sjalsligt-avkladd
rss-viktmedicinpodden
rikatillsammans-om-privatekonomi-rikedom-i-livet
sa-in-i-sjalen
rss-max-tant-med-max-villman
i-vantan-pa-katastrofen
rss-om-vi-ska-vara-arliga
psykologsnack
roda-vita-rosen
rss-i-skenet-av-blaljus