SharePoint to the core is a Content Management System & Hence we need to focus on the speed/size/cost of underlying Hard Disks.
SharePoint stores contents in the databases. The content can be divided as:
- Structured (list, document library columns)
- BLOBs (which can be configured to get stored in Remote BLOB storages)
Types of Drives
Following are the types of drives we usually encounter.
PATA, SATA (Parallel/Serial Advanced Technology Attachment)
They are magnetic spinning drives with speed around 7200 rpm (rotation per minute). The Parallel/Serial attributes the connector mechanism. Usually SATA drives are faster than PATA drives.
SCSI (Small Computer System Interface)
They have higher spinning speed than the PATA/SATA alternative. SCSI spins around 15000 rpm, but requires additional Motherboard Controllers leading to extra cost.
SSD (Solid State Drive)
SSDs use semi-conductors for storage, instead of magnetic components. They are typically double in speed than the SATA/PATA alternative. It is priced double than the normal hard disks. They typically connects well with a SATA cables.
SSDs are gaining popularity due to their increased speed.
Another technology of interest is Fibre Channel (FC) Storage which was initially used in super computers, but now common in SAN (Storage Area Network)
Question: What is the recommended size of content database in normal scenarios?
Question: What is the recommended size of content database in large-storage scenarios with high iops?
(IOPS = Input/Output operations per second)