dcsimg

Ten Steps You Shouldn't Take to Make Storage Run Faster

  • Ten Steps You Shouldn't Take to Make Storage Run Faster-

    In the database world, indexes are often the biggest challenge because by nature, index reads are random. A common tactic is to over-index tables in order to reduce the number of blocks that must be read from storage. This behavior can span the extremes. At one extreme is the method of creating an index containing all of the required columns needed by a query, so that the index itself supplies the data and no table access is necessary. Clever, but the overhead required to maintain numerous indexes is significant and has an impact on any insert, update or delete operation.

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12

Ten Steps You Shouldn't Take to Make Storage Run Faster

  • 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
  • Ten Steps You Shouldn't Take to Make Storage Run Faster-8

    In the database world, indexes are often the biggest challenge because by nature, index reads are random. A common tactic is to over-index tables in order to reduce the number of blocks that must be read from storage. This behavior can span the extremes. At one extreme is the method of creating an index containing all of the required columns needed by a query, so that the index itself supplies the data and no table access is necessary. Clever, but the overhead required to maintain numerous indexes is significant and has an impact on any insert, update or delete operation.

Typically, compromise can be a great thing – certainly a mandate in most relationships, but not in the world of IT, and especially not in the storage space. In IT, compromise always comes at a cost. For years, IT has been inventing and implementing workarounds to cope with the poor performance of storage systems bound by mechanical hard disks. As processor, memory and network speeds have repeatedly doubled over the years, storage media have failed to keep pace, creating unbalanced ecosystems.

Often, these compromises are so ingrained that they have become second nature. No thought is given to the overhead because no alternatives existed. That is, until now, with the proliferation of flash-based storage systems and the trajectory of the all-silicon data center.

Fahima Zahir, product marketing, Violin Memory, has identified the top 10 coping mechanisms found in today’s storage environments that should be avoided.