topic Re: Deploying SAS 9.3 Data Analytics - Performance Policy Recommendations for Data Warehouse Volume? in Array Performance and Data Protection https://community.hpe.com/t5/array-performance-and-data/deploying-sas-9-3-data-analytics-performance-policy/m-p/6984585#M735 <HTML><HEAD></HEAD><BODY><P>Based on this <A href="http://support.sas.com/kb/51/659.html">SAS KB 51659</A>, (from a past life), your key line in "SAS World" is pagesize:&nbsp; (Much like MS SQL)</P><UL><LI>-pagesize <N><BR /> Specifies the size of the page for I/O operation (for example, 8k, 64k, 128k). See the note on -pagesize below. If –pagesize is not specified the default is 8k. </N></LI></UL><P>So basically it's 8K, unless someone is changing it. (I wouldn't.) Which equates to SQL 2012 Data.&nbsp; (8K, Compression On, Cache On)</P><P>Remember, if you're doing an RDM or VMDK, don't bother with block sizes outside of 4K.</P><P>If you present a volume via Windows iSCSI Initiator, then you can leverage the 8K block size.</P><P>I'm pretty sure that's what you need. If anyone else has learned different, please let me know.</P></BODY></HTML> Tue, 16 Feb 2016 20:49:38 GMT alex_goltz 2016-02-16T20:49:38Z Deploying SAS 9.3 Data Analytics - Performance Policy Recommendations for Data Warehouse Volume? https://community.hpe.com/t5/array-performance-and-data/deploying-sas-9-3-data-analytics-performance-policy/m-p/6984584#M734 <HTML><HEAD></HEAD><BODY><P>The volume in question will be a stand-alone volume within Nimble.&nbsp; Within Windows, we'll format it with an allocation unit size of 64K since it will primarily be doing large sequential reads.&nbsp; However, not sure what performance policy to apply to this volume within Nimble.&nbsp; Anyone with experience with this who can lend a hand?</P></BODY></HTML> Fri, 13 Nov 2015 01:35:02 GMT https://community.hpe.com/t5/array-performance-and-data/deploying-sas-9-3-data-analytics-performance-policy/m-p/6984584#M734 thoule26 2015-11-13T01:35:02Z Re: Deploying SAS 9.3 Data Analytics - Performance Policy Recommendations for Data Warehouse Volume? https://community.hpe.com/t5/array-performance-and-data/deploying-sas-9-3-data-analytics-performance-policy/m-p/6984585#M735 <HTML><HEAD></HEAD><BODY><P>Based on this <A href="http://support.sas.com/kb/51/659.html">SAS KB 51659</A>, (from a past life), your key line in "SAS World" is pagesize:&nbsp; (Much like MS SQL)</P><UL><LI>-pagesize <N><BR /> Specifies the size of the page for I/O operation (for example, 8k, 64k, 128k). See the note on -pagesize below. If –pagesize is not specified the default is 8k. </N></LI></UL><P>So basically it's 8K, unless someone is changing it. (I wouldn't.) Which equates to SQL 2012 Data.&nbsp; (8K, Compression On, Cache On)</P><P>Remember, if you're doing an RDM or VMDK, don't bother with block sizes outside of 4K.</P><P>If you present a volume via Windows iSCSI Initiator, then you can leverage the 8K block size.</P><P>I'm pretty sure that's what you need. If anyone else has learned different, please let me know.</P></BODY></HTML> Tue, 16 Feb 2016 20:49:38 GMT https://community.hpe.com/t5/array-performance-and-data/deploying-sas-9-3-data-analytics-performance-policy/m-p/6984585#M735 alex_goltz 2016-02-16T20:49:38Z