Pre-UC I put out a teaser on some dbt2 scores in the 50K range. I mentioned and showed the graphs during my SSD session, but I thought I would show them here for those who skipped the UC or did not attend my session. Basically what most people consider to be a classic “CPU Bound” workload where all of your data easily fits into memory can also see benefits from moving to SSD’s. Remember just because everything fits into memory doesn’t mean your not going to be doing some operations to disk ( logging, flushes, etc ). Take a look:
|Regular Disk BBU (5.1.33)||46106.44||NA|
|SSD WO/Drive Cache (5.1.33)||50606.82||9.76%|
|SSD W/Drive Cache (5.1.33)||55793.47||21.01%|
|SSD WO/Drive Cache (5.4)||66286.95||43.77%|
|SSD W/Drive Cache (5.4)||70264.66||52.40%|
The other thing to note here is is the speed up in 5.4, that’s a pretty big performance improvement. Now of course with the drive cache enabled on the ssd’s you get a 10%+ boost in performance, but keep in mind its not 100% safe for your data unless you use some other mechanism to mitigate data loss on a power outage ( i.e. ups shuts down server ).
Because someone will ask:
Tests where done on a Sun 4450, 4 disks Intel Enterprise SSD, Raid 10, 16 core 2.93 GHZ cpu’s, adaptec controller with 256MB W BBU, 10K SAS drives. Optimal configuration for the SSD’s software raid, 64K Stripe size, Software raid, Disabled controller read & write cache.