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/

Episoder(287)

Episode 167: Azure SQL Data Sync

Episode 167: Azure SQL Data Sync

Azure SQL Data Sync has been generally available for almost a year now. Have you heard of it? Are you using it? Microsoft's page tell us that "Data Sync is useful in cases where data needs to be kept ...

25 Apr 201941min

Episode 166: Custom Visuals

Episode 166: Custom Visuals

The number one reason organizations choose Power BI is the ability to visualize data; however, even with all the immediate choices, many report developers desire to create custom visualizations. In th...

17 Apr 201929min

Episode 165: Artificial Intelligence

Episode 165: Artificial Intelligence

Why should I care about this episode? I know many of you are going to ask that question. Artificial Intelligence is getting lots of buzz and in this episode we invite Hope Foley from Microsoft to disc...

28 Mar 201941min

Episode 164: The DAX Episode

Episode 164: The DAX Episode

DAX is the acronym for Data Analysis Expressions, and it is the formula language used throughout Power BI. In this episode we talk about DAX concepts and how they are simple and straightforward, but c...

21 Mar 201925min

Episode 163: Very Large Databases

Episode 163: Very Large Databases

Are you experiencing challenges managing Very Large Databases (VLDBs), or anticipate challenges with future growth? In this episode, we are joined by Aaron Hayes to discuss the practical advice on man...

13 Mar 201940min

Episode 162: Power Query vs DAX

Episode 162: Power Query vs DAX

In this corner, coming in with all its Excel glory we have Power Query! And in this corner we have a new programming language, DAX! Have you ever felt like there is a tug of war going on between these...

28 Feb 201928min

Episode 161: Migrating/Upgrading 8000 databases

Episode 161: Migrating/Upgrading 8000 databases

How do you migrate 8,000 databases on a single instance in an environment that doesn't tolerate downtime? Today's episode focuses on migration strategy and how our guest Andy Levy faced the challenge ...

21 Feb 201945min

Episode 160: Power BI Embedded

Episode 160: Power BI Embedded

The traditional model for Power BI is to pay per user, but what if you want to use the reports in your web app and don't know who all the users would be? In this episode the team explores Power BI Emb...

13 Feb 201930min

Populært innen Fakta

fastlegen
dine-penger-pengeradet
relasjonspodden-med-dora-thorhallsdottir-kjersti-idem
mikkels-paskenotter
foreldreradet
rss-strid-de-norske-borgerkrigene
treningspodden
rss-bisarr-historie
jakt-og-fiskepodden
takk-og-lov-med-anine-kierulf
sinnsyn
rss-sunn-okonomi
hverdagspsyken
tomprat-med-gunnar-tjomlid
gravid-uke-for-uke
fryktlos
rss-bak-luftfarten
ukast
lederskap-nhhs-podkast-om-ledelse
level-up-med-anniken-binz