Database Flash Memory Storage

Hard disks have become so huge that less than $200 will now buy you a 500GB external drive in a store. Still, flash drives are catching up in size whilst providing far better access speeds and power usage. (Dell are charging $800 for a 32GB Flash Drive for my laptop – enough to be usable)

Today, major SQL Server installations are unlikely to use flash drives, but the common belief is that this will change in the near future.

But before you start planning for these great 10x performance gains, you should spend some time to understand the underlying differences, and see that it is in fact the nature of your data reads and writes that will affect performance. It really isn’t as uniform as you might think, and it is worth to read the following paper on the subject:

http://www.cs.cmu.edu/~damon2007/pdf/graefe07fiveminrule.pdf

________________________________________

Update: Spoke too soon.. the flash drive for database systems is just around the corner

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s