SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSD PCI Express vs. 15k drives


SSD PCI Express vs. 15k drives

Author
Message
sqlnyc
sqlnyc
SSC-Enthusiastic
SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)

Group: General Forum Members
Points: 132 Visits: 871
Greetings fellow DBAs --

Just started a new DBA gig, and have unfortunately inherited a textbook version of how NOT to use SQL Server. Client is running 2008R2 Enterprise, with a db size of ~100GB. Due to massive performance problems they have already moved to SSD on PCI Express, and enabled Row Committed Snapshot Isolation, because of frequent deadlocks.

The SQL environment is not run in-house, but instead is hosted. They are getting quotes on moving to a new hosting provider, and the specs I saw mentioned internal 15k magnetic drives. I warned them that this would likely be a mistake. Now they want to see a bench mark that would determine the potential performance hit if making this kind of switch. I realize that an apples-to-apples comparison like this might not have been done, so I'll phrase it another way.

Is there a way to configure 15k drives either internal to the server or DAS that would perform in the ballpark of SSD PCI Express drives?

Thanks very much in advance for any advice.
sqlnyc
sqlnyc
SSC-Enthusiastic
SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)

Group: General Forum Members
Points: 132 Visits: 871
Wondering how to go about moving this post to the SQL 2008 general forum. Moderator(s)?

Thanks--

sqlnyc
GSquared
GSquared
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24123 Visits: 9730
I found a bechmark test here: http://www.8088.net/blog/index.php/2011/01/24/iops-comparison-solid-state-drive-ssd-15000-7200-5900-5600-rpm/?lang=en#chart

I haven't done 15k vs SSD in a database environment, but on every machine I've ever tested on, SSD and platters just aren't comparable. Simply eliminating seek-time on random (non-sequential) I/O makes them incomparable, completely ignoring all other factors.

Collateral advantages, like lower power-consumption, and collateral disadvantages (like lower repeatable-write durability, resulting in lower MTBF), probably don't matter as much in a hosted environment, since you won't be paying their electric/cooling costs, and won't pay directly for drive-replacement if part of a RAID array fails. And modern SSD MTBF on enterprise-grade hardware is pretty good. Much better than 10 years ago. So that may not even be a factor.

But in terms of I/O, it's kind of like asking "which is faster, a Schwinn or a Porche 911?" Not the same breed of vehicle.

Of course, code-refactoring is usually the right answer to slow databases. That and/or normalization. But if hardware is critical, hopefully the above link will help.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
sqlnyc
sqlnyc
SSC-Enthusiastic
SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)

Group: General Forum Members
Points: 132 Visits: 871
GSquared - thanks so very much for the advice and the link. Exactly what I was looking for, but despite searching often, I couldn't find something like this.

Much obliged --

Best wishes,

SQLNYC
Nadrek
Nadrek
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1943 Visits: 2729
Note also that replacing a failed PCIe SSD is going to require shutting the server down. Replacing hot-swap drives (SSD or spindle) does not.

PCIe SSD's need to be in a software RAID or a SQL Server HA/DR setup to have serious failure tolerance; SAS and SATA drives generally use hardware RAID on modern servers.
Abel A.
Abel A.
SSC Rookie
SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)

Group: General Forum Members
Points: 47 Visits: 66
I wouldn't recommend PCIe ssd because they're just a pain. My advice would be to run 6 x 512GB SSD in RAID-10. The thing to remember about ssd drives in an array is that there's no trim support. Trim is usually not that big of a deal in a database environment because most data doesn't get deleted. Another thing is that you would need to over-provision your array to say 300GB. I would only recommend Intel or Samsung ssd brands, don't buy any other brand. My favorite are the Samsung 830s.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search