1 Reply Latest reply: Feb 16, 2016 12:49 PM by Alex Goltz RSS

    Deploying SAS 9.3 Data Analytics - Performance Policy Recommendations for Data Warehouse Volume?

    Talbert Houle Wayfarer

      The volume in question will be a stand-alone volume within Nimble.  Within Windows, we'll format it with an allocation unit size of 64K since it will primarily be doing large sequential reads.  However, not sure what performance policy to apply to this volume within Nimble.  Anyone with experience with this who can lend a hand?

        • Re: Deploying SAS 9.3 Data Analytics - Performance Policy Recommendations for Data Warehouse Volume?
          Alex Goltz Adventurer

          Based on this SAS KB 51659, (from a past life), your key line in "SAS World" is pagesize:  (Much like MS SQL)

          • -pagesize [N]
            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.

          So basically it's 8K, unless someone is changing it. (I wouldn't.) Which equates to SQL 2012 Data.  (8K, Compression On, Cache On)

          Remember, if you're doing an RDM or VMDK, don't bother with block sizes outside of 4K.

          If you present a volume via Windows iSCSI Initiator, then you can leverage the 8K block size.

          I'm pretty sure that's what you need. If anyone else has learned different, please let me know.