High IO, High IO, It's a Case Study Yo Ho!
Duration: 60 minutes
Track: Room 350
Confronted with the highest IO of any Windows server in our environment one intrepid DBA was able to reduce IO, space consumption, and blocking to new lows. This is a case study, based upon actual events where the names of the innocent as well as the guilty are changed to protect the DBA. Topics covered: DMVs, online operations, Filegroups, Page Compression, and disk formatting best practices.