Unsolved
This post is more than 5 years old
6 Posts
0
1013
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
Kumar_A
727 Posts
0
April 21st, 2015 14:00
Follow the best practice recommendations in the Host Configuration Guide for XtremIO (available at support.emc.com).
dmuegge
17 Posts
0
April 25th, 2015 20:00
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)
}
}