I don’t know of any best practices to follow with SQL on NFS datastores. There’s no special alignment consideration.

 

From: Klise, Steve <Steve.Klise@wwt.com>
Sent: Wednesday, March 7, 2018 10:16 PM
To: Iluhes <iluhes@yahoo.com>; Toasters <toasters@teaparty.net>; toasters-request@teaparty.net
Cc: Parisi, Justin <Justin.Parisi@netapp.com>
Subject: Re: Netapp-_NFS_datastore_VMware__SQL VM__NTFS

 

I didn’t really find anything.  I looked at the VMWare SQL best practices, and there is little to no reference for NFS, but there is some for VMFS.  Maybe Justin Parisi can chime in on the NFS if he’s watching (and willing. ☺  ).   I am guessing if you use snapcenter for SQL, it will properly align and meet NA best practices for SQL.  Here was a good video on Sql SnapCenter..   Sorry, couldn’t help.

 

SnapCenter for SQL

https://www.youtube.com/watch?v=MopbUFSdHKE

 

SQL best practices

https://www.vmware.com/content/dam/digitalmarketing/vmware/en/pdf/solutions/sql-server-on-vmware-best-practices-guide.pdf

 

 

 

From: Iluhes <iluhes@yahoo.com>
Date: Wednesday, March 7, 2018 at 5:46 PM
To: "toasters@teaparty.net" <toasters@teaparty.net>, "toasters-request@teaparty.net" <toasters-request@teaparty.net>, "Klise, Steve" <Steve.Klise@wwt.com>
Subject: Re: Netapp-_NFS_datastore_VMware__SQL VM__NTFS

 

Steve,

Thank you! I have seen the doc as well. My question is how this is applicable to NFS based VMs

There is not lun here. The vmware datastore is on NFS volume. VMWARE to Netapp NFS is 4k, right?

 

 

On Wednesday, March 7, 2018, 7:09:23 PM CST, Klise, Steve <Steve.Klise@wwt.com> wrote:

 

 

May want to read the best practices TR below. 

 

 

Page 20

Create LUNs with SnapDrive for Windows or SnapCenter whenever possible. If you want to create LUNs with DiskManager or other tools, make sure that allocation unit size is set to 64K for partitions during formatting the LUNs.

 

 

https://www.netapp.com/us/media/tr-4590.pdf

 

 

From: <toasters-bounces@teaparty.net> on behalf of Iluhes <iluhes@yahoo.com>
Date: Wednesday, March 7, 2018 at 4:24 PM
To: "toasters@teaparty.net" <toasters@teaparty.net>, "toasters-request@teaparty.net" <toasters-request@teaparty.net>
Subject: Netapp-_NFS_datastore_VMware__SQL VM__NTFS

 

that is residing on NFS (not VMFS or RDM) datastore.

Is it still 4K? MS recommendations are for larger size (64K)

NFS datastore!