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 239: Bi-directional HA/DR to Azure SQL

Episode 239: Bi-directional HA/DR to Azure SQL

SQL Server 2022 has been announced and we are excited to start unpacking the new features. For this episode, we start with a very interesting feature--Bi-directional HA/DR to Azure SQL. We have the ab...

15 Dec 202134min

Episode 238: Getting Started with Power BI - Part 2

Episode 238: Getting Started with Power BI - Part 2

Part 2 Power BI has been described as a "self-service" BI platform. While that may bring to mind an image of easy-peasy, plug-and-play, there are a few things most organizations will want to address b...

8 Dec 202131min

Episode 237: Getting Started with Power BI - Part 1

Episode 237: Getting Started with Power BI - Part 1

Part 1 Power BI has been described as a "self-service" BI platform. While that may bring to mind an image of easy-peasy, plug-and-play, there are a few things most organizations will want to address b...

1 Dec 20211h 6min

Episode 236: Database Monitoring with SQL Sentry

Episode 236: Database Monitoring with SQL Sentry

Building your own scripts to monitor SQL Server seems like a very reasonable thing to do. We're smart folks and SQL Server is what we do for a living—we should be able to figure this out. Upon further...

17 Nov 202142min

Episode 235: SQL Trail 2021 In-person Q&A

Episode 235: SQL Trail 2021 In-person Q&A

Live Podcast! We decided it was time to try and get together in person and reconnect. As we did, we pulled out the microphone and started recording. As a result, we break the single topic mode this we...

3 Nov 202125min

Episode 234: Communication Tips for the IT Pro

Episode 234: Communication Tips for the IT Pro

As a data pro, you are negotiating and problem-solving all the time, often without knowing it. Your success as a professional as your company evolves its Data Platform depends on how well you can comm...

7 Okt 20211h 1min

Episode 233: ScriptDOM

Episode 233: ScriptDOM

Never heard of ScriptDOM? Neither had we…okay, except Kevin, who obviously knows all. Apparently, the documentation is scarce. Mala Mahadevan uses it, loves it, and graciously offered to come back to ...

15 Sep 202146min

Episode 232: Giving Technical Presentations

Episode 232: Giving Technical Presentations

Public speaking is not fun for most; however, it can be very rewarding. Chris Seferlis chats with us about a few tips he has on being a speaker. Most of the tactical advice we defer to a toastmasters ...

1 Sep 202154min

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