I'm looking at using SSD to improve DB performance in a large data warehouse. In our instance we know in advance that most of the data is write once, read many - especially as it's reference data. Does anyone have experience of doing this for real? In addition for the OS/Application, is it possible to seperate out those files which are changed frequently and put them on normal HDD.
I'm aware of the issues with performance degrading over time and not wanting to write fast changing data to the drive.
Edit -> I realise that I can partiton my DB and point certain tables at certain drives. The question is has anyone done it and was it worth it. Similarly what about the OS assuming Server 2003 - which files should go onto SDD, which onto HDD and how do you persuade the OS to split itself in that way?