SQL Server Hardware Choices Made Easy

Introduction......Page 6
1	Know your workload type, Part 1......Page 8
2	Don't economize on the CPU......Page 10
3	More cores, fewer sockets…......Page 11
4	Don't dismiss hyper-threading (Intel processors)......Page 13
5	Don't focus just on speed: cache size is very important......Page 15
6	Use the High Performance power option......Page 17
7	Use "turbo boost" technology......Page 19
8	Carefully evaluate the motherboard and associated chipsets......Page 23
9	Two x 2-sockets is usually better than one x 4-socket......Page 25
10	Optimize memory capacity......Page 27
11	Use 64-bit hardware, operating system and SQL Server......Page 29
12	Understand SQL Server licensing restrictions......Page 30
13	Use the built-in hardware discovery tools......Page 31
14	Get to know your hardware intimately with CPU-Z......Page 35
Tip_15......Page 37
Tip_16......Page 39
Tip_17......Page 42
Tip_18......Page 44
Tip_19......Page 46
Tip_20......Page 48
21	$2,000 buys a very capable dev/test system......Page 52
Intel Socket 1366......Page 53
Intel Socket 1155 platform......Page 54
Storage choices......Page 55
22	For a laptop, choose a Sandy Bridge processor (July 2011)......Page 56
Configuring the disk subsystem......Page 60
Tip_23......Page 61
24	Attached storage: for magnetic drives choose SAS or SATA......Page 63
25	Start planning to incorporate SSDs......Page 64
26	Use the correct RAID level, ideally RAID 10......Page 65
27	High-performance DAS is a reality......Page 68
28	Maximize spindle count and I/O channel performance......Page 69
29	Use CrystalDiskMark to measure I/O capacity......Page 73
Tip_30......Page 75
Appendix A: Recommended Intel and AMD processors......Page 77
_GoBack......Page 16
_GoBack......Page 58