We are experiencing packet loss on our SQL 2012 Always On Windows Clusters operating in our virtual environment.
Through troubleshooting, we found that we needed to increase the Small RX buffers on our SQL 2012 Always On Clusters default from 1024 to 8192. (link below)
I can do this in the GUI all day, but in our environment there are several Always On 2012 installations where this parameter needs to be changed.
I followed the link below, and I do not find the settings changes reflected in the registry (even after reboot), so I can refer to the key for the change.
Note. I am running Windows Server 2008 R2 with clustering (wanting me to be on Windows Server 2012 with new PowerShell commands).
I am looking for a suitable place to update this parameter, this method can be anything but click through the GUI (I have steps for the GUI in the link below).
Is there a way to update Small Rx Buffers through a script in Windows Server 2008 R2?
Link: http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=2039495
source
share