I was asked to look at an issue recently with bad IO performance on an SQL VM. SQLio tests were being run and the figures coming back were much lower than expected. There was a little bit of CPU Ready but only occasionally, and the environment was slightly overcommitted. However, after some quick investigation windows task manager showed that the iSCSI traffic was going over the Production Virtual NIC!?!?!
The VM had 2 NICs. One for Production traffic and one for iSCSI, connected to different networks and only the Production NIC had a default gateway set. However the iSCSI Filer IP was on the same subnet as the iSCSI NIC (accessed using a Microsoft iSCSI Initiator) so why wasn’t traffic routing down that NIC? There was no overlap so I ran a
Here’s where I went down some rabbit holes and fixed some issues.
The routing table showed that the default gateway had a lower Metric than the NIC that was on the same subnet. I thought this was the issue initially so I set about trying to get the Metric for the iSCSI connected NIC lower.
I learned some things about how Windows 2012 Automatically works out metrics for NICs.
More detail can be found here <A HREF=https://support.microsoft.com/en-us/kb/299540>https://support.microsoft.com/en-us/kb/299540</A>
It was then that I spotted something I had taken for granted….the virtual NIC types were differet. Somehow this VM had been configured wrong by whoever added the iSCSI NIC and they had selected e1000 !!!
Changing the NIC type to VMXNet3 meant the line rate jumped up to 10Gbps from 1Gbps and now the Metric for the iSCSI nic was the same as the Production default gateway…but not lower.
I tried manually editing the Production NIC’s default gateway metric to add 300 to it to make it higher.
This did make the routing table look right from a metrics perspective….but still the traffic went over the Production NIC. Thankfully after bouncing the issue off a few colleagues one did come back with a config guide for Microsoft iSCSI Initiator on 2012.
Now I hadn’t configured the initiator either, we have a storage team who did that. They had just left some settings default, and it appears that iSCSI ignores your IPv4 Routing Table in Windows. So all my fidgetting above was in vain (although it did highlight the build issue with e1000 vs VMXNet3).
Microsoft’s guide does state
(Ideally include this in a template/blueprint or at a minimum highlight it in your build documentation)
I hope that saves you the morning I had!