Advise needed on 8 drive configuration and spec

JLJ

JLJ

Associate
Joined
5 Feb 2007
Posts
150
Hi,

I'm trying to work out what storage to buy for a Datawarehouse SQLServer server.
It needs to run SSIS, SSAS & SSRS and both production and test.
As its a DW, the logging is simple, and not critical.
Hoping there might be some gurus to shed some light.
Size wise, the DW is about 250GB, but I think the cost of excess capacity is a non issue as we see this growing rapidly in the next 18 months.
Load wise, unknown

So far:
2 X SSD 240GB - tempdb and logs RAID 1
2 X SAS 900GB 15k - SSAS, ? , RAID ?
4 X SAS 1.8TB - mdf RAID 10

We are also getting SQL Server Enterprise, so I am now able to partition tables.
However seeing as the data is all on a RAID 10 volume, does that mean that its a single partition?
I read somewhere not to partition a RAID volume.
Does this mean I lose the benefits of table partitioning or its still there as its the RAID 10 will handle it.
Any comments or tips would be appreciated.
 
Associate
Joined
1 Feb 2009
Posts
2,124
Single hardware or you happy to build a cluster? Any SAN in your environment currently?

PErsonally I'd go with 2x dl380's in a HA Cluster if you have SAN, that way your disks can grow by a simple SAN Extension. If you have no SAN, then without knowing your total amount of storage required over the life of the sql, its abit hard to judge.

Ideally you want raid 5 to give you some form of redundancy, maybe even go fancy SSD's for data if price isnt too much of an issue
 
Back
Top Bottom