Storage
HDD vs SSD vs Flash
Even if you place all copies of your redo logs on the SSD, you are still likely to see performance degradation. This is expected because as we discussed before, SSD doesn’t have any performance benefit for sequential writes of the type redo logs usually experience, and it may even end up being slower. Our experience at Pythian with customers attempting to place redo logs on SSD confirms this issue, and so do the tests ran by Guy Harrison.
https://blog.pythian.com/de-confusing-ssd-for-oracle-databases/
SSD is not the same as an all-flash array. An all-flash array is able to avoid the consequences of [the above] restrictions by managing the flash globally, so that erases do not block reads and writes.
https://flashdba.com/2013/08/22/storage-myths-put-oracle-redo-on-ssd/
SSD as long-term storage
SSDs tend to have a longer MTBF than HDD (NVMe also tends to be longer than SATA SSD). However, without being connected to a stable power supply, the data would arguably survive for somewhere between a few months and a few years due to the natural degradation inherent in the quantum physics underlying SSD technology..Â
If you want to store the data on a shelf, long-term, without power then HDD or high quality Optical (e.g. Blu-Ray) may be, theoretically, a better choice.Â
If you keep the drive plugged in and monitored, especially if it is part of a RAID configuration, then SSD and HDD are more evenly matched (you will, theoretically, need to swap out less SSDs due to failure, but you will likely pay more for each one compared to HDD. HDDs will consume more power, but SSDs can be sensitive to temperature and power fluctuations. In the event of drive failure, data recovery from HDD tends to have a higher chance of success).
All electronic storage is vulnerable to other risk like solar storms, fire, water or obsolesence.
If you print out the data using good quality paper and ink and protect the paper from damp, UV, and fire then you could realistically expect the data to survive for several hundred years.
SAN vs NAS
CMR vs SMR
In Conventional Magnetic Recording (CMR) tracks are adjacent to each other with a small gap between.
In Shingled Magnetic Recording (SMR) tracks slightly overlap (like roof shingles). This allows for more tracks and thus higher capacity but leads to old data being overwritten. To avoid data loss the overwritten data must be written somewhere else. This is not really an issue for a user PC or laptop, since there is plenty of idle time to allow for this housekeeping. However, in a constant I/O environment there is likely to be a noticeable performance hit.
SMR is not recommended for...
Database Servers
ZFS
Identifying CMR/SMR
Some manufacturers provide lists (see the CMR/SMR section of the Bibliography on this page).
If your drive supports TRIM it is likely SMR
- For Windows you can identify TRIM support using a tool like CrystalDiskMark.
- For UNIX you can use a tool like GSmartControl.
Database Storage
Transfer rates are representative. Real world results will vary.Acronyms
AAM
AHCI - Advanced Host Controller Interface
APM
CIFS
CMR - Conventional Magnetic Recording
DASD - Direct Attach Storage Device
DAFS - Direct Access Filesystem
DSN
DWPD - Drive Writes Per Day
ECC - Error Correction ?
HDD - Hard Disk Drive
IDE
JBOD - Just a Bunch Of Disks
MLC - Multi-Level Cell (NAND)
MTBF - Mean Time Between Failures
NAND
NAS - Network Attached Storage
NFS - Network Filesystem
QLC - Quad-Level Cell (NAND)
RAID - Redundant Array of Inexpensive Disks
SAME - Stripe And Mirror Everything
SAN - Storage Area Network
SAS
SATA - Serial AT Attachment (AT stands for "Advanced Technology" in reference to the IBM AT PC)
SCSI
SMART - Self-Monitoring, Analysis, and Reporting Technology
SLC - Single-Level Cell (NAND)
SMR - Shingled Magnetic Recording
SSD - Solid State Disk
TBW - Terabytes Written
TLC - Triple-Level Cell (NAND)
TRIM
WRL - Workload Rate Limit
ZFS
Bibliography
Database Storagehttps://www.brentozar.com/archive/2025/01/does-separating-data-and-log-files-make-your-server-faster/https://www.brentozar.com/archive/2017/06/separating-data-log-files-make-server-reliable/
Brandshttps://www.nasmaster.com/seagate-ironwolf-vs-seagate-ironwolf-pro/https://www.seagate.com/content/dam/seagate/en_gb/content-fragments/products/datasheets/ironwolf-pro-12tb/ironwolf-pro-20tb-DS2129-4-2311US-en_GB.pdfhttps://www.seagate.com/content/dam/seagate/migrated-assets/www-content/datasheets/pdfs/ironwolf-12tb-emea-DS1904-21-2207GB-en_GB.pdfhttps://www.seagate.com/www-content/datasheets/pdfs/3-5-barracudaDS1900-11-1806US-en_US.pdf
RAIDhttp://www.raid-calculator.com/default.aspx
Filesystemshttps://www.iperiusbackup.net/en/refs-vs-ntfs-differences-and-performance-comparison-when-to-use/
Performancehttps://hdd.userbenchmark.com/https://ssd.userbenchmark.com/https://superuser.com/questions/680589/how-can-i-achieve-maximum-sustained-sequential-disk-write-performancehttps://learn.microsoft.com/en-us/biztalk/technical-guides/using-the-performance-analysis-of-logs-pal-toolhttps://github.com/clinthuffman/PAL
AWR (Annualised Workload Rate) / WRL (Workload Rate Limit)https://www.seagate.com/gb/en/support/kb/annualized-workload-rate-005902en/https://superuser.com/questions/1313180/what-does-180tb-per-year-workload-mean-on-the-wd-red-12tb
Reliabilityhttps://www.backblaze.com/blog/backblaze-drive-stats-for-2023/
IOPShttp://storagearchitect.blogspot.com/2008/09/how-many-iops.htmlhttps://en.wikipedia.org/wiki/IOPS#Exampleshttps://wiki.horde.org/HardwareRequirements
NAShttps://www.reddit.com/r/PleX/comments/11b7afx/what_would_be_the_best_nas_server_for_a_plex/https://www.androidcentral.com/best-nas-plexhttps://uk.pcmag.com/nas/14710/the-best-nas-network-attached-storage-devices
vSANhttps://blogs.vmware.com/virtualblocks/2019/04/18/vsan-disk-groups/
SSDhttps://ssd.userbenchmark.com/https://www.quora.com/What-is-the-average-read-write-speed-of-an-SSD-hard-drivehttps://www.quora.com/Why-is-SSD-not-a-good-option-for-long-term-storagehttps://www.quora.com/Is-the-modern-new-2023-built-SSD-reliable-for-long-term-storage
CMR/SMRhttps://www.broadbandbuyer.com/Advice/4348-cmr-vs-smr-what-the-difference/https://techwiser.com/smr-vs-cmr-drives-comparison/https://www.seagate.com/gb/en/internal-hard-drives/cmr-smr-list/https://blog.westerndigital.com/wd-red-nas-drives/https://toshiba.semicon-storage.com/ap-en/company/news/news-topics/2020/04/storage-20200428-1.html
SATAhttps://tripplite.eaton.com/products/sata-cables-and-speeds-compared
Bandwidth vs Transfer Speedhttps://learningnetwork.cisco.com/s/blogs/a0D3i000002SKQrEAO/bandwidth-vs-speedhttps://www.digitalsamba.com/blog/network-speed-vs-bandwidth-vs-throughputhttps://superuser.com/questions/1633000/max-read-write-speed-of-a-sata-3-0-hdd-rated-at-6-0gb-s
Back in my first job, must have been about 1988, we had one of these (see video, right), made by Honeywell. It used one of those big blue 30 amp plugs but we didn't have enough 30 amp sockets, so we swapped it for a standard 13 amp 3 pin plug. Armed with some spare fuses, one of my jobs was to spin the disk up to a reasonable speed using my hand then slam the lid shut and shout, "Now!", to a colleague who would throw the switch on the socket.