THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Paul Nielsen

www.SQLServerBible.com

256Gb SSDs and WordPerfect for Windows

Samsung has announced a new 256Gb solid state drive. Production will begin later this year. The initial market is for notebooks, but the real market is for databases. 

SSD drives are faster than hard disks, more reliable, and have different access method performance patterns. Hard drives perform best while sequentially accesses large blocks of data. SSDs are equally capable of accessing random data or sequential data.

This change is as significant as the change from paper tape to mag tape, or mag tape to hard drives. Database vendors that grok this evolutionary step and rewrite their storage engine to optimize for SSD drives will survive. Those that don't will go the way of WordPerfect for Windows (WordPerfect once owned 99% of the word processing market. WordPerfect didn't move to Windows very gracefully, and as a result, many PC users don't even remember WordPerfect.)

 

Published Monday, May 26, 2008 11:23 AM by Paul Nielsen
Filed under: , ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Jason said:

May 26, 2008 7:29 PM
 

alen said:

i've kept up with SSD news a little, but wasn't there a limitation on the number of writes? it wasn't an issue with things like digital cameras but using it like a HD is different. and what about seek time? i thought it was a lot longer than regular hard disks.

May 27, 2008 11:08 AM
 

Jason said:

There is some SQLIO test data over here. http://sqlstuff.info/post/2008/03/SSD-and-SQL---SQLIO-performance.aspx I think it is inconclusive based on the test systems except that SSD totally excels at random reads which should be the bulk in an OLTP workload. The EVA on server 2 is a > $150k SAN. I would like to see how 20-30 striped SSD drives with a stout controller compare write-wise. The tests also do not mention disk caches and raid controller caches which should also be configured to optimize writes since sql uses the RAM as read cache.

May 27, 2008 3:05 PM

Leave a Comment

(required) 
(required) 
Submit

About Paul Nielsen

Paul Nielsen believes SQL is the romance language of data. As such he’s a hands-on database developer, Microsoft SQL Server MVP, trainer, and author of SQL Server Bible series (Wiley). As a data architect, he developed the concepts of Smart Database Design and Nordic – an open source O/R dbms for SQL Server. He lives in Colorado Springs.

This Blog

Syndication

News

news item test
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement