In case you were wondering, or have never heard of solid state disk – or haven’t checked it out, I encourage you to do so. Solid State Disk is a hybrid between programmable RAM and disk drive hardware to replace a physical read/write head on magnetic type of media. It speeds up your servers and laptops anywhere between 20x and 150x.
Theres a study with SQLServer and SSD that provides some interesting findings, and interesting numbers. http://www.sqlservercentral.com/articles/SSD+Disks/69693/ I’d encourage you to check it out. I’m impressed with the performance, but it goes deeper than that. I’ve written before about Temperature of Data, well with SSD you don’t need to “worry” too much about Temperature of Data, as all the data on the SSD ends up being mostly in RAM.
However, because of the price/cost barrier – I would strongly suggest that “hot data” or operational data that is flowing in to the Data Vault be put on SSD, and the rest on traditional storage. This will help to manage cost, and performance gains. By exercising this type of architecture with the Data Vault, the benefits of the DV model in partitioning become very very clear. The benefits include being able to put only the hubs, links, and satellites that are affected by the operational data – on the SSD components. There is no need (unless you can afford it) to put the entire Data Vault model on the SSD. BUT the performance gains are HUGE, HUGE, HUGE.
Now, you have the flexibility of the DV model, while at the same time – the performance of the SSD under the covers. What a win! To top it off, if you add enough CPU power, you can stay on a massive SMP system, and increase parallel query engines with incredible efficiency gains. (That’s the one thing the author of the article didn’t yet talk about – is what kind of partitioning and parallel query they had configured – if any).
I recommend SSD to those of you suffering with Performance problems, and some hardware upgrade funding to help along the way. But again, go lightly (like the article says), only replace the parts of your data warehouse that are most used, or suffer from the most performance issues.
Remember this: SSD in laptops and desktops are NOT the same as enterprise SSD drives (hence the cost difference). Server based SSD drives are built with different technology and can respond to RAID cards within the server, and different types of memory allocations and bandwidth. BUT SSD in your laptop can increase your laptops performance by at least 10x, however the down side (I’ve heard) is SSD draws a significant amount of battery power – when on battery.
Do you have questions about SSD and Data Vault? I’d like to hear them.