UP

Statistics for SSDSA2SH064G (Intel X25-E with 64G, SLC)

I always had a problem to figure out, if ssds are good or bad for databases. So in the end i just tried it out, keeping backups always handy, though. Until now no problems at all. I expect to get the first errors in a year.

stats for one disk:

 WriteCacheSupport     : Yes           WriteCache            : Disabled
 RLACacheSupport       : Yes           RLACache              : Disabled
 SMARTFeatureSetSupport: Yes
 SMARTSelfTstSetSupport: Yes           SMARTErrorLogSupport  : Yes
 CmdQueuingSupport     : NCQ           CmdQueuing            : Enabled
 CmdQueueDepth         : 31            MultiDMASupport       : MDMA2
 UltraDMASupport       : UDMA5         DMAMode               : UDMA5
 MediumErrorThreshold  : 0

 DataTransferred     : 127.79TB
 ReadDataTransferred : 76.05TB         WriteDataTransferred: 51.74TB

 Errors              : 0               NonRWErrors         : 0
 ReadErrors          : 0               WriteErrors         : 0

 IORequest           : 1,175,466,806   NumOfMediumErrors   : 0
 NonRWRequest        : 298,744
 ReadIORequest       : 1,934,104,533
 WriteIORequest      : 3,536,030,825

 StatsStartTime      : Jan 13, 2010 00:49:50
 StatsCollectionTime : Mar 21, 2011 10:23:47

Stats for the raid6, that includes the disk above. The volume runs oracle on it. Lots of writes. All SSD.

 DataTransferred     : 477TB
 ReadDataTransferred : 240.10TB        WriteDataTransferred: 236.90TB

 Errors              : 0               NonRWErrors         : 0
 ReadErrors          : 0               WriteErrors         : 0

 IORequest           : 250,098,542
 NonRWRequest        : 6,026,383
 ReadIORequest       : 1,075,645,495
 WriteIORequest      : 3,463,393,960

 StatsStartTime      : Jan 13, 2010 00:49:50
 StatsCollectionTime : Mar 21, 2011 10:25:37
Mon Mar 21 11:52:06 CET 2011 Feedback: public@ecopatz.de