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!
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!
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!
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/...
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!
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/...
From: Iluhes <iluhes@yahoo.commailto:iluhes@yahoo.com> Date: Wednesday, March 7, 2018 at 5:46 PM To: "toasters@teaparty.netmailto:toasters@teaparty.net" <toasters@teaparty.netmailto:toasters@teaparty.net>, "toasters-request@teaparty.netmailto:toasters-request@teaparty.net" <toasters-request@teaparty.netmailto:toasters-request@teaparty.net>, "Klise, Steve" <Steve.Klise@wwt.commailto: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.commailto: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.netmailto:toasters-bounces@teaparty.net> on behalf of Iluhes <iluhes@yahoo.commailto:iluhes@yahoo.com> Date: Wednesday, March 7, 2018 at 4:24 PM To: "toasters@teaparty.netmailto:toasters@teaparty.net" <toasters@teaparty.netmailto:toasters@teaparty.net>, "toasters-request@teaparty.netmailto:toasters-request@teaparty.net" <toasters-request@teaparty.netmailto: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!
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/...
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!
-
Iluhes -
Klise, Steve -
Parisi, Justin