question

r_balaji_g avatar image
r_balaji_g asked

Failover Cluster Insance with FusionIO

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.
always-on
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

DenisT avatar image
DenisT answered
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.
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Many Thanks! Yes we are indeed mirroring (using 2 fusion IO PCI cards) within the same physical server using RAID-1
0 Likes 0 ·
pchinnam avatar image
pchinnam answered
,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
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.