Post reply

A fatal error occurred while reading the input stream from the network. The session will be terminated

  • May 10, 2016 at 10:20 pm

    #307377

    Hello All,

    I have checked on the sql server error log and event viewer and found that it seems like network releated issue and It happens quite randomly.

    But I don’t see the "Remote Host" or "Localhost" from sys.dm_os_ring_buffers.

    I have noticed the below error in the error log at the time the process got terminated.

    Error: 4014, Severity: 20, State: 10.

    A fatal error occurred while reading the input stream from the network. The session will be terminated (input error: 10054, output error: 0).

    Observed that memory utilization is normal(Phyisical RAM 24GB,allocated SQL server Max memort 12GB)

    With help of MSDN,found that to disable Receive-Side Scaling State and need to try this option.

    But not sure this is last option to troubleshoot this issue further or need to increase the network packet size at database level or server level on client machine or target Database server?

    in what traces we need to enable to check network connectivity issues?

    or Need to contact Security\Windowsetwork team investigate further.

    FYI..tcp chimney is already disbaled.

    ENvironment is SQL server 2012 and WIndows server 2012 OS.

    Please suggest how to troubleshoot this issue furthe

    Thanks in advance!!

    I will appreciate your help with this situation

    SQL server DBA

  • May 10, 2016 at 10:33 pm

    #1878040

    Take a look at this article http://www.sqlserverlogexplorer.com/causes-of-sql-error-4014/[/url] this informative article shows the reason behind SQL Server error 4014 and possible solution to fix the error.

  • May 11, 2016 at 3:15 am

    #1878081

    Thank you for your quick response and I have checked below article as you suggested,TCP Chimney offload already disabled and Need to disable the RSS (Receive side scaling state and need to try this option .

    only way to need to check with windows or Network team for below things.

    Solution

    Make sure that all latest updates are installed on the server machine. Check out if following updates are installed properly.

    •The update for network adaptor. This comes under firmware or driver update section.

    •The BIOS update for the server. This might need an update as a work around to the problem.

    Please suggest if you have any other opinions or suggestions.

    SQL server DBA

  • May 11, 2016 at 9:01 am

    #1878267

    Hello All,

    Please suggest on next steps to troubleshoot this issue further.

    Thanks in advance!!

    SQL server DBA

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply