Thank you all. I will do it like said:

clustered index -> data-filegroups

nonclustered index -> index-filegroups

Thanks for the quick replies 😉

Thanks for your info.

But I must say, I tried to put the clusterd key index in another filegroup and it worked.

I not saying that it makes sense but it worked...

> How big are the tables that you are looking to partition

We have non historising tables that have about 130 Million rows. Growing about 50.000 rows per day.

Additionally we have...

As you can read in several articles there is a discussion whether putting in more then one file for each filegroup is increasing performance or not.

However they all seam to...

Cheers Mate,

that is what I was hoping for. Nowing that the database is balancing itself between the files in an filegroup fixes the problem, so I can use to Hardware-Raids...

Help 🙂

I guess you mean by DAS - Direct-attached storage?!

The global hot spares are used to fill in whenever a disc crashes. As you never know, if the mirroring disc of...

The systems are quite similar

both are Dell PowerEdge R900 with 4x xeon-6-Core and 128GB RAM

the DWH has a total DB-Space 3,5 TB RAID10

and additionally backup-place 9TB Raid6

the ETL has 700GB...