Our company is going to use SAN (HP or EMC or Fuji) for SQL Server failover rather than MSCS. So far, DBA has no knowledge of SAN.

Would you please to tell me, how does SAN depend on SQL Server? I assume SAN software can make disk failover if there is a network, disk or OS failure in primary node. If SQL Server or SQL Agent is failure, can SAN software detect it? (or can SAN disk failover depend on SQL Server or SQL Agent services?)

Please let me know where can I find any configuration document regarding SAN for SQL Server failure. I had spent 2 days in HP and EMC wrbsite and found nothing.

Happy Thanksgiving.

Mary