topic Re: NetApp + Microsoft Cluster + SQL Cluster - HowTO in Microsoft Virtualization Discussions

NetApp + Microsoft Cluster + SQL Cluster - HowTO

PLASTIQUE — Thu, 05 Jun 2025 06:27:24 GMT

Hello everyone

My Colleague is on hospital right now and he´s the best one handling the NetApp here. He won’t be back for 8 weeks so I have to get a new 2-node Active/Passive SQL Cluster up and running on my own..

What I have is Windows 2008 Server ENT, SQL Server 2008 R2 STD. And VMware ESX 4 with vSphere Virtual Center. And ofc the NetApp Filers. I have today a big VMware environment up and running with some 400 VM´s on the NetApp, but no Windows Clusters.
I would like to have some guidance where it comes to installation order of all components and some on configuration of those:

Microsoft Cluster Services
MPIO
iSCSI initiator ( well it´s on the control panel )
NetApp Host Configuration Utility
NetApp SnapManager
NetApp SnapManager for SQL
Microsoft SQL Server

And where and from what I create and bind the LUN:s, resources in the right order for the cluster services.

I haven’t found any real help on the internet for this scenario, and since my colleague is on hospital, everything has to happen right now, a thousand things to do..

The only thing I found that I have been thinking about is this scenario: https://communities.netapp.com/community/netapp-blogs/msenviro/blog/2011/02/18/install-order-for-hyper-v-clusters But i Don’t know if I need to have MPIO, Host Configuration Utility and so on.

Can you help me with some guidance please

Re: NetApp + Microsoft Cluster + SQL Cluster - HowTO

PLASTIQUE — Tue, 15 May 2012 07:42:37 GMT

A hard nut to crack ?

Re: NetApp + Microsoft Cluster + SQL Cluster - HowTO

radek_kubka — Tue, 15 May 2012 14:33:55 GMT

Hi and welcome to the Community!

Few questions:

- are you talking about clustered SQL nodes running on physical hardware, or as VMs on top of vSphere?

- what version of SMSQL are we talking about?

- what version of SnapDrive?

Regards,

Radek

Re: NetApp + Microsoft Cluster + SQL Cluster - HowTO

PLASTIQUE — Tue, 15 May 2012 15:04:29 GMT

Yes two Windows 2008 cluster nodes with SQL 2008R2 on top of VmWare

SMSQL 5.0R1

SnapDrive 6.3.1R1

Re: NetApp + Microsoft Cluster + SQL Cluster - HowTO

radek_kubka — Tue, 15 May 2012 15:17:54 GMT

So this is a very tricky subject then.

For a starter, 'proper' iSCSI (via VMware stack) is not supported for Microsoft clusters:

http://www.vmware.com/pdf/vsphere4/r40/vsp_40_mscs.pdf, p12

VMware is hinting a workaround in vSphere 5 by using software iSCSI initiator inside a guest:

http://pubs.vmware.com/vsphere-50/topic/com.vmware.ICbase/PDF/vsphere-esxi-vcenter-server-50-mscs-guide.pdf, p9

But this is not the recommended setup on the NetApp side - all recent best practices suggest using VMware iSCSI stack, which brings us to square 1: MSCS not supported.

Re: NetApp + Microsoft Cluster + SQL Cluster - HowTO

PLASTIQUE — Tue, 15 May 2012 15:31:57 GMT

My intention is to use Windows iSCSI initiator withing windows for the LUN:s used by SQL

Re: NetApp + Microsoft Cluster + SQL Cluster - HowTO

radek_kubka — Tue, 15 May 2012 15:48:57 GMT

A a bit risky scenario - especially if you have no extensive experience with NetApp (if I understand your initial post correctly).

You can easily find some best practices documents here (limit search to Technical Reports):

http://www.netapp.com/library/

but I don't think any of them will match your exact requirement.

Re: NetApp + Microsoft Cluster + SQL Cluster - HowTO

abhisek — Tue, 15 May 2012 15:51:09 GMT

Please look through TR 3941 for helping you on the deployment and prerequisites.Also read through TR 3785 .

Regards,

Abhishek

Re: NetApp + Microsoft Cluster + SQL Cluster - HowTO

PLASTIQUE — Tue, 15 May 2012 22:20:17 GMT

So you think that it should work?

Re: NetApp + Microsoft Cluster + SQL Cluster - HowTO

PLASTIQUE — Fri, 18 May 2012 15:26:26 GMT

Where should i install the SQL binaries ? Can i put those on a VMDK-file and have the binaries only there, or do I have to put the binaries on a LUN together with the system databases ?

Re: NetApp + Microsoft Cluster + SQL Cluster - HowTO

radek_kubka — Fri, 18 May 2012 15:56:46 GMT

SQL binaries should be on VMDK file in my view.

Re: NetApp + Microsoft Cluster + SQL Cluster - HowTO

PLASTIQUE — Mon, 21 May 2012 10:34:47 GMT

For this cluster, should I create separate volumes for Quorum, MSDTC and Data ? Like this ?:

Volume1, will be for LUN Quorum

Volume2, will be for LUN MSDTC

Volume3, will be for SQL Databases and logfiles

And question 2, shuld I Snapshot Quorum and MSDTC ? I guess not, and this is the case of not placing them on the same volume as the Snapped Volume3 for SQL Databases.

Re: NetApp + Microsoft Cluster + SQL Cluster - HowTO

radek_kubka — Wed, 23 May 2012 10:46:46 GMT

Hi,

One comment: normally you would separate SQL db & logs into separate volumes.

Regards,

Radek

Re: NetApp + Microsoft Cluster + SQL Cluster - HowTO

PLASTIQUE — Wed, 23 May 2012 10:55:53 GMT

Aha, why and exactly how do you mean ?

Re: NetApp + Microsoft Cluster + SQL Cluster - HowTO

radek_kubka — Wed, 23 May 2012 14:01:42 GMT

E.g. have a look at already mentioned TR: http://media.netapp.com/documents/tr-3941.pdf

It's about how SMSQL backup & recovery works.

Re: NetApp + Microsoft Cluster + SQL Cluster - HowTO

PLASTIQUE — Thu, 31 May 2012 10:56:18 GMT

When configuring SnapManager for SQL, should I install and configure this on both cluster nodes ? Anything special to consider ? Should each cluster node have it´s own SnapInfo-LUN, or should I have one and put it in the SQL Resource Group ?

Re: NetApp + Microsoft Cluster + SQL Cluster - HowTO

thomas_glodde — Thu, 31 May 2012 11:24:43 GMT

You must install SnapManager SQL on all nodes. Each instance should have as a minimum

DB Drive

DB Log Drive

System DB & Log Drive

Snapinfo Drive

So yes depending on your setup you might need to have more SnapInfo Disks. SM SQL can also deal with volume mountpoints if you run out of drive letters.

Re: NetApp + Microsoft Cluster + SQL Cluster - HowTO

PLASTIQUE — Thu, 31 May 2012 11:37:40 GMT

Thank you

I have:

Lun1: User Database and log

Lun2: System Database and log

Lun3: Temp Database and log

When configuring SMSQL, should I enter the Cluster name for SQL or each node in the initial screen

Re: NetApp + Microsoft Cluster + SQL Cluster - HowTO

thomas_glodde — Thu, 31 May 2012 13:04:33 GMT

You need to split Lun1

Lun1 User Database

Lun2 User Database Log

Lun3 Syste, Database and Log

Lun4 Temp Database and Log

Lun5 NetApp SMSQL SnapInfo

When configuring backup jobs enter the cluster name.

Re: NetApp + Microsoft Cluster + SQL Cluster - HowTO

PLASTIQUE — Thu, 31 May 2012 13:07:24 GMT

Aha

Can the Userdb and Userdblog LUN´s be on the same volume ?