Hi, We are upgrading our SQL Server infrastructure from 2008 version to SQL Server 2014. Ours is a hybrid environment with both Data warehouse(abt 70%) and OLTP(about 30%) type of workloads. We want to use Fail Over Cluster Instance (FCI) for SQL instance level failover protection. We also want to use FusionIO card for tempdb to improve performance as our existing application processes use tempdb heavily. Going through Microsoft documentations it seems, for FCI to work, the storage should be a Shared Connection between Active and Passive servers. Given this, is it possible to use FusionIO PCI cards(attached to motherboards of individual servers) for tempdb? All other databases will be using shared connection to SAN. (also we have to use SAN and not other alternatives such has SMB JBOD, etc as per our company's existing standards) Will FCI work with this type storage of configuration? Your input is greatly appreciated.
Q: is it possible to use FusionIO PCI cards(attached to motherboards of individual servers) for tempdb? Yes, it is. Starting with SQL Server 2012 Microsoft officially supports local TempDB in a cluster configuration. So you are good to go! The only comment I have is to make sure you pair your FusionIO cards into RAID-1 because if the the card fails, you lose your TempDB and the instance fails as well.
,Hi Balaji, did you explore using Fusion IOs for FCI with the help of Data Keeper which simulate shared storage(SAN) for Fusion IO disks. Which looks promising solution leveraging IOPS as weel as high availability. Appreciate your thoughts