Good Benchmarks Comparing SSD to Traditional SAS and SATA Drives for SQL Server

AnandTech (which is my favorite hardware review website) has a very interesting post up that compares performance between 15K SAS drives, 5400 SATA drives and Intel X25-E SLC SSD drives, using IOMeter and SQLIO, among other benchmarks.

The gist of the test is that conventional hard drives are faster (and cheaper) for sequential access loads such as transaction logs in SQL Server, while the Intel Solid State Drives (SSD) are much faster (and more expensive) for random access such as SQL Data files.

One thing I would like to test would be how SSDs affect TempDB performance. Maybe my friends at SQLCAT Best Practices can do some testing at their lab in Redmond?

Technorati Tags: ,

This entry was posted in Computer Hardware. Bookmark the permalink.

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