question

Yasarmistry-3565 avatar image
1 Vote"
Yasarmistry-3565 asked SeanGallardy-MSFT commented

DIrect LUN mapping or shared VHDX

Hi,
i have quick question,
We have Have currently 2 SQL HA configured... and using iscsi initiotr and mapped the LUN from storage to direct virtual machine...

but now that storage has issue so we buy new storage but that storage doesnt support Iscisi only FC

so could you please let me know which option is good to to use for SQL HA for performance point...

1- Shared VHDX
2- Again direct LUN mapping to Virtual machine...(from storage to Virtual machine)

Please advise i am bit confused...

Thanks

sql-server-generalwindows-server
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SeanGallardy-MSFT avatar image
1 Vote"
SeanGallardy-MSFT answered SeanGallardy-MSFT commented

You can't use a shared VHDX file unless you are clustering the VMs on the same host, which defeats the whole point of clustering. You'll need to map the to all of the possible hosts the guest could run on and then map the lun to the guest.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for reply,

But i have currently running SQL HA cluster only over iscsi and i have mapped the same LUN to my both SQL virtual server...
Now my old storage is out of so we bought new storage where there is no iscsi option only i have FC connection and My HBA card doesn’t support the NPIV So i unable to map the LUN direct to virtual machine
My question is
Which is good option if i migrate my sql database
If i create 2 new virtual machine and map same shared
VHDX and configure the SQL so it will be fine a d performance?
Or
I need to have better again do mapping direct in to virtual machine (RDM mapping?..

Or is there any other way also which i can use for sql cluster
Which option i should select... please advise...

1 Vote 1 ·

If i create 2 new virtual machine and map same shared VHDX and configure the SQL so it will be fine a d performance?

I answered this, you can't do clustering across hosts with a shared VHDX. You can't have two guests use the same underlying drive in a stand alone configuration either, so there shouldn't be any questions on this.

I need to have better again do mapping direct in to virtual machine (RDM mapping?..

As I stated, this is your only worthwhile option for clustering SQL Server.

1 Vote 1 ·
AlexBykovskyi avatar image
1 Vote"
AlexBykovskyi answered Yasarmistry-3565 commented

Hey,

You can deploy a Failover Cluster on your hosts and deploy SQL FCI on top without a need to create nested cluster. This scenario won't create additional layers and easier to manage. The following guide might be helpful:
https://www.starwindsoftware.com/resource-library/starwind-virtual-san-installing-and-configuring-sql-server-2019-tp-failover-cluster-instance-on-windows-server-2016/

Cheers,

Alex Bykovskyi

StarWind Software

Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for reply,

But i have currently running SQL HA cluster only over iscsi and i have mapped the same LUN to my both SQL virtual server...
Now my old storage is out of so we bought new storage where there is no iscsi option only i have FC connection and My HBA card doesn’t support the NPIV So i unable to map the LUN direct to virtual machine
My question is
Which is good option if i migrate my sql database
If i create 2 new virtual machine and map same shared
VHDX and configure the SQL so it will be fine a d performance?
Or
I need to have better again do mapping direct in to virtual machine (RDM mapping?..

Or is there any other way also which i can use for sql cluster
Which option i should select... please advise...

1 Vote 1 ·