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.
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.