Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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).

share|improve this question
I suspect the reason there's no answers is because it can't be done. My knowledge of clustering isn't very vast, but I can think of a lot of barriers that will stop this from being technically possible. – Mark Henderson Nov 3 '10 at 1:05
You may want to look at a RAMSAN if your IOPS requirements are really this high, and you absolutely must cluster. – Chris Thorpe Nov 3 '10 at 23:54

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


Like I said, YMMV

share|improve this answer
That is a most excellent hack, and right up there at the top of the list of things you do only if you know EXACTLY what you're doing and why. – sysadmin1138 Nov 3 '10 at 5:30
Thanks for the second link! (I was unfortunately already aware of the first one) – SQL3D Nov 3 '10 at 21:31

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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.