April 14, 2011 at 10:07 am
I have 14 drives total, 2 internal, 12 hot swap. I'm also not worried about backups since they are stored on different systems, so I have 12 available JUST for MSSQL data.
April 14, 2011 at 11:51 am
datawiz (4/14/2011)
The server has 24GB of memory. What about removing the RAID10 array for Logs, and replace it with 1 RAID1 array for Logs and 1 RAID1 array for tempdb? Or should I keep the Logs array, and just put tempdb on either the Data or Indexes array? I am mostly concerned about hardware failure, performance wise, even a single disk in this new machie would be faster than the existing server (which uses 7200RPM IDE drives).2 disk - RAID1 - OS
2 disk - RAID1 - Logs
2 disk - RAID1 - TempDB
4 disk - RAID10 - Data
4 disk - RAID10 - Indexes
or
2 disk - RAID1 - OS
4 disk - RAID10 - Logs
4 disk - RAID10 - Data (/TempDB?)
4 disk - RAID10 - Indexes (/TempDB?)
I would go with the later.
2 disk - RAID1 - OS
4 disk - RAID10 - Logs
4 disk - RAID10 - Data (including TempDB)
4 disk - RAID10 - Indexes
Even better IMHO would be:
2 disk - RAID1 - OS
2 disk - RAID1 - Logs
6 disk - RAID10 - Data (including TempDB)
4 disk - RAID10 - Indexes
That gives you a good initial setup. IF at some point in the future you need to expand simply get a Dell PowerVault (external storage array) w/ 24 drive bays.
http://www.dell.com/us/business/p/powervault-md1220/pd
You then could do load enough additional spindles to do things like:
a) expand data partition
b) move logs to larger/faster RAID10 array
c) move tempdb to a dedicated 4 or 6 drive RAID10 array
etc
Still I think that day likely would be far off.
April 27, 2011 at 7:36 am
Is there a way of specifying the 'default' path for Indexes?
Also, with the Analytics service, I see the option to specify the Log path, can I put this on the Logs array, or should it be somewhere else?
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply