Home / server / Questions / 197490
In Process
SQL3D
Asked: 2010-11-03 14:46:15 +0800 CST

Fusion-IO ioDrives in SQL Server cluster

  • 772

Has anyone successfully set up a Fusion-io ioDrive (or similar product) in a Windows cluster for SQL Server? (I would be interested in either Windows Server 2003 or 2008 and SQL Server 2005 or 2008).

We are looking into the possibility of setting up 2 cards on each node in the cluster (RAID 1) to house the TempDB database.

Specifically we are interested in how you would trick windows clustering service to recognize this local "drive" as a cluster resource. (I'm well aware this is unsupported by MS).

sql-server tempdb windows-cluster

2 Answers

  1. tempdb is disposable and rebuilt on restart anyway.

    I'd try moving it to the local disks and see what happens. You shouldn't need to add them as a resource. YMMV of course.

    User databases + master, msdb, model etc should be on the shared disks

    Edit:

    Like I said, YMMV

    • 2

  2. Please find (MVP) Jonathans experience doing this exact same thing with Fusion IO cards.

    http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/0cea0082-24ef-4843-9720-15e3593926ac

    • 0