Why database partitioning didn't work? Extract from thedailywtf.com
- by questzen
Original link. http://thedailywtf.com/Articles/The-Certified-DBA.aspx.
Article summary: The DBA suggests an approach involving rigorous partitioning, 10 partitions per disk (3 actual disks and 3 raid). The stats show that the performance is non-optimal. Then the DBA suggests an alternative of 1 partition per disk (with more added disks). This…