dmathew1
1 Nickel

XtremIO/VMware ESXi 5.5 and SQL 2008R2/2014 best practices....EMC XtremIO – Setting Disk.SchedNumReqOutstanding On vSphere 5.5 (PowerCLI)

Ive read that with XtremIO and vSphere 5.5, it is recommended to increase the default setting of 32 max number of active storage commands (I/O) to 256. The workload on XtremIO is SQL. The specific ESXi setting is associated to "Disk.SchedNumReqOutstanding"  Is this recommendation true?  Please advise.


Thanks,

Dee

Tags (3)
0 Kudos
2 Replies
8 Krypton

Re: XtremIO/VMware ESXi 5.5 and SQL 2008R2/2014 best practices....EMC XtremIO – Setting Disk.SchedNumReqOutstanding On vSphere 5.5 (PowerCLI)

Follow the best practice recommendations in the Host Configuration Guide for XtremIO (available at support.emc.com).

0 Kudos
dmuegge
6 Indium

Re: XtremIO/VMware ESXi 5.5 and SQL 2008R2/2014 best practices....EMC XtremIO – Setting Disk.SchedNumReqOutstanding On vSphere 5.5 (PowerCLI)

Yes, to get the most out of XtremIO storage these settings are recommended for maximum performance.

The setting you refer to is used in esxi 5.1 which is required because in 5.1 this setting is done at the host level and applies to all LUNS. The command below is a rough example of what you would use for the setting.

Get-VMHost $ESXHost | Get-AdvancedSetting -name Disk.SchedNumReqOutstanding | Set-AdvancedSetting -Value 256

In esxi 5.5 this changed and the setting can be set for individual LUNS. A rough example of this command is below.

$esxcli = Get-EsxCli -VMhost $esx

$devices = $esxcli.storage.core.device.list()

foreach ($device in $devices)

{

    if ($device.Vendor -like "XtremIO"){

        $esxcli.storage.core.device.set($null, $device.Device, $null, $null, $null, $null, $null, 256, $null)

    }

}

0 Kudos