Balance the System Resources:– Allocate 4 GB – 8 GB of system memory per CPU core– For Business Intelligence systems, 200 GB -300 GB ofactive raw data per CPU core– I/O Capacity should be measured in Megabytes persecond or I/Os per second, not am...
显示全部Balance the System Resources:– Allocate 4 GB – 8 GB of system memory per CPU core
– For Business Intelligence systems, 200 GB -300 GB of
active raw data per CPU core
– I/O Capacity should be measured in Megabytes per
second or I/Os per second, not amount of disk space
– At least 10 – 20 disks per CPU core
• For example, for a 4-way system, use 8 disk arrays with 8
disk drives in each array for a total of 64 disks (ratio 16
disk :1 CPU core)
– For Systems with high rates of logged changes,
dedicate disks to the database logs:
• A RAID-1 pair of disks can provide enough logging
throughput for up to 400 transactions per second.
• A RAID-10 array with write caching can be used to support
higher logging rates
收起