SQL Server Error: 4014

SQL Server Error: 4014

The test machine under the line always error, from errorlog to see a large number of 4014 errors

 while 0 0  4014.

So Google a bit, found an article: https://www.mssqltips.com/sqlservertip/3538/fixing-sql-server-fatal-error-4014/

You know now the network card built-in features are more powerful, some functions can even replace the CPU to execute, so Microsoft released scalable Networking Pack (SNP) Scalable network package, scalable network package includes the following 3 main functions

TCP/IP Chimney Offload
Receive Side Scaling (RSS)
Network Direct Memory Access (NetDMA)

You can use the following command to see if the above 3 features are enabled

int TCP show global

The general operating system will turn on the chimney offload function by default, this is the TCP/IP network packet push function, the CPU processing is now given to the network card processing, reduce the CPU burden, speed up the network packet processing speed

But not all network cards support chimney offload function, because the offline test machine is a normal home PC, so the NIC driver does not have this built-in function

The workaround is to disable chimney offload

int TCP set global chimney=int TCP set global rss=disabled

After disabling, then execute the netstat command to see if processing is migrated back to the CPU

Netstat-t

If the last column is Inhost, then the processing logic for the packet is done on the CPU, not on the NIC

At this point, the problem solved, errorlog also found no 4014 error

If there is a wrong place, welcome everyone to shoot brick O (∩_∩) o

SQL Server Error: 4014