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/
Episode 37: PowerBI and the DBA
Episode 36: SQL Server Virtual Machines in Azure
Episode 35: Position Yourself to Better Opportunities
Episode 34: In-Memory Tables
Episode 33: From Developer To DBA
Episode 32: Up Your Game With PowerShell!
Episode 31: What Has Virtualization Done To My Database?
Episode 30: The Best Investment You Can Make
Episode 29: You Thinking What I Am Thinking?
Episode 28: How Do You Know There Is A Problem? Baselines!
Episode 27: Testing Changes Before You Break Production
Episode 26: DevOps for the Database--Everyone is Doing it, Right?
Episode 25: Stretch Database
Episode 24 Query Store
Episode 22: Eight Years of sp_whoisactive
Episode 21: Azure Data Factory
Episode 20: the Role of Mentors
Episode 19: How Solid State Disks Can Help SQL Server
Episode 18: BIML
Create your
podcast in
minutes
It is Free
Insight Story: Tech Trends Unpacked
Zero-Shot
Fast Forward by Tomorrow Unlocked: Tech past, tech future
The Unbelivable Truth - Series 1 - 26 including specials and pilot
Elliot in the Morning