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 97 Transactional Replication
Epsiode 96 Building Community Tools
Episode 95 Polybase
Episode 94 Qlik Technologies
Episode 93 Making Mistakes
Episode 92 SSDT
Episode 91 DBA Tools
Episode 90 Check DBCC
Episode 89 Lone DBA
Episode 88 SharePoint
Episode 87 Resource Governor
Episode 86 TsqlT
Episode 85 2016 Speedbumps
Episode 84 MVP
Podcast 83 Data Visualizations
Episode 82 Indexes Part 2
Episode 81 Indexes Part 1
Episode 80 Containers
Episode 79 SSIS Catalog
Episode 78: Conversion to 2016
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