SQL Server Hardware Selection

GeekBench Results:

Storage Types :
Internal drives in the database server
PCI-E flash storage in the database server
Direct-attached storage (DAS)
Storage area network (SAN)
Server message block (SMB) file shares — Only with Windows Server 2012

Traditional magnetic drives vs. flash-based storage
Magnetic drives are much less expensive (and still most common)
Magnetic drives have poor random I/O performance
Flash-based storage has extremely high random I/O performance
Flash-based storage also has higher sequential performance
A small number of SSDs

Considering Your Workload for Storage

SQL Server can have several different workload types
Three most common types:
Online Transaction Processing (OLTP)
Relational Data Warehouse (DW)
Online Analytical Processing (OLAP)
These workload types have different I/O access patterns
OLTP workload has frequent writes to data files and log file

Also has random reads from data files if database does not fit in memory
Random I/O performance is very important
DW workload has large sequential reads from data files
Sequential I/O performance is very important
OLAP workload has lots of random reads from cube files
Random I/O performance is very important

Best Storage Options for SQL Servers Databases:

RAID 10 is called a striped set of mirrors
Data is mirrored and then striped
Possible to survive the loss of more than one drive
Requires a minimum of four physical drives
Must be an even number of physical drives
No write performance penalty
Very well-suited to write intensive workloads
Ideal for SQL Server log files

Leave a Reply

Your email address will not be published. Required fields are marked *