We SQL Server 2005 x64 with SP3. We have 2 GB RAM and it's development server.
We are moving 100 GB data from one database to other database on the same instance.
The process terminated and noticed the below error in the error log at the time the process got terminated
Error: 4014, Severity: 20, State: 2.
A fatal error occurred while reading the input stream from the network. The session will be terminated.
I went through the below links :
Link one says, tcp chimney should be disabled. In our environment, on SQL Servers, tcp chimney is disabled already ---ruled out
Link two says, memory is getting paged out. But I did not see any memory errors or memory dumps in error log. How to make sure that the process was terminated because of memory paging?
And the error says that the Session will be terminated. How to find out which session got terminated?