Sh*t Happens.... lol. cords get pulled by accident, OSs crash, etc. I will have a UPS but neither is a replacement for the other.
For what its worth SLOG with an Intel 750 made a huge difference with sync writes. They still weren't at async levels but very close. LSI 9208 HBA w/ 8-2TB seagate wolf NAS (5900rpm consumer level) with striped mirrors. I was getting in the neighborhood of 350MB/s sequential writes (async) with sync it was closer to 50MB/s I added the 750 as a SLOG with sync=always on the pool and I was seeing 300MB/s or so. The write tests were very close to the local storage sata 6 SSD I had on my host. Random write tests obviously were not as good. Reads I'm not sure of... With my 10GB iSCSI HBA i was getting just over 1000MB/s but at that level its quite possible my NIC with overhead was a limiting factor (I hadn't done much tuning yet... no JumboFrames etc). My theoretical max read would be 180(single drive rating)x8 which puts me at 1440.
With all of that being said a SLOG should be well worth it for anyone that requires the safety of synchronized writes for their VMware environment and uses a RAID with platters. Remind you I have mirrored stripes! NOT RAIDZ and I was getting 50MB/s
Also.... I couldn't help myself and I can't see myself 'wasting' a 400GB $300 drive. SO I ordered another one... lol. I am NOT using this in a full prod environment and it will be my lab holding 20 some odd VMs that I will be using throughout the week for testing. Since I've already spent a good amount of money on RAM, mobo, CPU etc... I've decided to step back and redesigned a bit. I'm going to run these striped only (800GB total) on one of my pools and I will be using mpio (my cards have 2 ports just needed a 1$0 twinax cable) Is this a good idea in prod (HELL TO THE NO) but its for my lab. I will also thin provision, use compression and dedup on this store. I will have maybe 3 different types of OSs but most of the guests will have lots that can be dedupd.
My platters will be for 'backup'. I'm going to use RaidZ2 to get back some extra space (write speed would be nice but not realtime critical) I'll end up recovering an extra 4 GB and I will under provision the pools by 80% which should give me shy of 10 TB (no dedup but compression) I will make daily/weekly clones as needed and use the store for ISOs, build software etc. I think it's a good compromise.
TLDR; Bought a SLOG.... tested with good results... Decided to buy my SLOG a friend and give them both new jobs.
Will turn my platters to 10TB of 'backup' space instead of 4GB worth of 'ESXi guest' space (8TB total in mirrored striped + underprovisioned 50%) . If I had to do it over again I may have just gone for 3 good PCIe's on RaidZ ( 900MB write speed on one drive probably 800MB on RaidZ for 3) and had Mirrored 6TB drive for 'backups' probably best of both worlds but hey.... Its been a lot of fun these past few weeks.