Mailing List Archive

Netapp-_NFS_datastore_VMware__SQL VM__NTFS
What is the best practice for formating a NTFS partion to be used for MS SQL data drive on the VMWARE VMthat is residing on NFS (not VMFS or RDM) datastore.Is it still 4K? MS recommendations are for larger size (64K)NFS datastore!
Re: Netapp-_NFS_datastore_VMware__SQL VM__NTFS [ In reply to ]
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

What is the best practice for formating a NTFS partion to be used for MS SQL data drive on the VMWARE VM
that is residing on NFS (not VMFS or RDM) datastore.
Is it still 4K? MS recommendations are for larger size (64K)
NFS datastore!
Re: Netapp-_NFS_datastore_VMware__SQL VM__NTFS [ In reply to ]
Steve,Thank you! I have seen the doc as well. My question is how this is applicable to NFS based VMsThere 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:

#yiv5637317451 #yiv5637317451 -- _filtered #yiv5637317451 {panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv5637317451 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv5637317451 {panose-1:2 0 5 3 0 0 0 2 0 4;}#yiv5637317451 #yiv5637317451 p.yiv5637317451MsoNormal, #yiv5637317451 li.yiv5637317451MsoNormal, #yiv5637317451 div.yiv5637317451MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;}#yiv5637317451 a:link, #yiv5637317451 span.yiv5637317451MsoHyperlink {color:#0563C1;text-decoration:underline;}#yiv5637317451 a:visited, #yiv5637317451 span.yiv5637317451MsoHyperlinkFollowed {color:#954F72;text-decoration:underline;}#yiv5637317451 p.yiv5637317451msonormal0, #yiv5637317451 li.yiv5637317451msonormal0, #yiv5637317451 div.yiv5637317451msonormal0 {margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv5637317451 span.yiv5637317451EmailStyle18 {color:windowtext;}#yiv5637317451 .yiv5637317451MsoChpDefault {font-size:10.0pt;} _filtered #yiv5637317451 {margin:1.0in 1.0in 1.0in 1.0in;}#yiv5637317451 div.yiv5637317451WordSection1 {}#yiv5637317451
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

 

What is the best practice for formating a NTFS partion to be used for MS SQL data drive on the VMWARE VM

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

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

NFS datastore!
Re: Netapp-_NFS_datastore_VMware__SQL VM__NTFS [ In reply to ]
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



What is the best practice for formating a NTFS partion to be used for MS SQL data drive on the VMWARE VM

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

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

NFS datastore!
RE: Netapp-_NFS_datastore_VMware__SQL VM__NTFS [ In reply to ]
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<mailto:iluhes@yahoo.com>>
Date: Wednesday, March 7, 2018 at 5:46 PM
To: "toasters@teaparty.net<mailto:toasters@teaparty.net>" <toasters@teaparty.net<mailto:toasters@teaparty.net>>, "toasters-request@teaparty.net<mailto:toasters-request@teaparty.net>" <toasters-request@teaparty.net<mailto:toasters-request@teaparty.net>>, "Klise, Steve" <Steve.Klise@wwt.com<mailto: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<mailto: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<mailto:toasters-bounces@teaparty.net>> on behalf of Iluhes <iluhes@yahoo.com<mailto:iluhes@yahoo.com>>
Date: Wednesday, March 7, 2018 at 4:24 PM
To: "toasters@teaparty.net<mailto:toasters@teaparty.net>" <toasters@teaparty.net<mailto:toasters@teaparty.net>>, "toasters-request@teaparty.net<mailto:toasters-request@teaparty.net>" <toasters-request@teaparty.net<mailto:toasters-request@teaparty.net>>
Subject: Netapp-_NFS_datastore_VMware__SQL VM__NTFS



What is the best practice for formating a NTFS partion to be used for MS SQL data drive on the VMWARE VM

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

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

NFS datastore!
Re: Netapp-_NFS_datastore_VMware__SQL VM__NTFS [ In reply to ]
Thank you Justin very much!


> On Mar 8, 2018, at 8:58 AM, Parisi, Justin <Justin.Parisi@netapp.com> wrote:
>
> 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
>
>
>
> What is the best practice for formating a NTFS partion to be used for MS SQL data drive on the VMWARE VM
>
> that is residing on NFS (not VMFS or RDM) datastore.
>
> Is it still 4K? MS recommendations are for larger size (64K)
>
> NFS datastore!