We have a couple of 200GB SSDs for fast cache and due to some SQL performance concerns we're looking to buy some additional SSDs to remedy but my would it be possible to temporarily remove the fast cache disk and use them for a short round of tests? If it is possible how would I go about doing this? Will it cause any issue or just lose the performance benefits for the period the disks are out?
Hi You can destroy the fastcache and reuse the disks. the operation will cause all the data in the fast cache to be destaged to disk, and this can have a performance impact on your array, and take quite a long time. And remember that this is on top of not having any fast cache...So of your array has the overhead to do this no problems, but if it has been designed to just meet your IOPS with the Fastcache included in the IOPS calculations, this may not be a good idea.
When the array was spec'd it didn't include any FAST cache in the original design. We later added this as a bonus due to some extra budget. Once we've finished testing the SSD's is it just a case of re-creating the FAST cache and off we go?
I suspect we'd probably go down the RAID 10 route if we were going to purchase additional disks as a result of the tests. Depends how much they want to spend though as 1600 per disk isn't cheap!
can't do a whole lot with 2 drives, mirror only (that's how Fast Cache is configured as well). I am trying to sqeeze as much usable capacity, so i always use RAID-5 for EFDs.
It is worth noting that during the process of creating and destroying Fast Cache, the SP Cache is temporarily disabled. Therefore, in the case of SP write cache, it will be disabled for as long as it takes to destage its contents.
I simply want to mention this as during that time while data is still of course accessible throughout the process, you may want to consider this when you schedule the activity.
Was your question answered correctly? If so, please remember to mark your question Answered when you get the correct answer and award points to the person providing the answer.
Remembering to mark the question Answered helps others with similar problems and awarding points helps motivate people to take the time answer you questions.
Jim_Hegner
2 Intern
•
212 Posts
488
0
Posted November 5th, 2012 03:00
Hi You can destroy the fastcache and reuse the disks. the operation will cause all the data in the fast cache to be destaged to disk, and this can have a performance impact on your array, and take quite a long time. And remember that this is on top of not having any fast cache...So of your array has the overhead to do this no problems, but if it has been designed to just meet your IOPS with the Fastcache included in the IOPS calculations, this may not be a good idea.