High IO, High IO, It's a Case Study Yo Ho!

Speaker(s)Tim Ford 

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.


SQLSaturday