Thursday, September 21, 2017

partition - BI Server raid/array configuration

I'm currently maintaining a BI server that crunches numbers for reports etc. It is running on a HP ProLiant 360DL G5 32gb ram with a Smart Array p800 connected to a MSA Unit with 750 GB in RAID 1+0 (total 1.5 TB, each disk is 72GBx22 disk). The server it self has 136 GB for OS and 3 logical partitions for Database (293 GB), StageDatabase (292 GB) and DWHDatabase (165 GB). I've been asked to assign each of these partitions to physical disks in the MSA unit, is this possible? Furthermore, I've read that best practice for SQL Servers should be that I change the raid for the OS to Raid 1, and the raid for the data should be raid 1+0?



The primary question here is, how do I map the logical drives to the physical drives?




I'm sorry if it's a stupid question, server setup is quite new to me.

No comments:

Post a Comment

linux - How to SSH to ec2 instance in VPC private subnet via NAT server

I have created a VPC in aws with a public subnet and a private subnet. The private subnet does not have direct access to external network. S...