Hi, today i found this error in the error log file: "Message A fatal error occurred while reading the input stream from the network. The session will be terminated." and the Stack Dump immediatelly after that: 2007-06-08 01:23:21.56 spid73 Error: 4014, Severity: 20, State: 8. 2007-06-08 01:23:21.56 spid73 A fatal error occurred while reading the input stream from the network. The session will be terminated. 2007-06-08 02:01:56.57 Server Using 'dbghelp.dll' version '4.0.5' 2007-06-08 02:01:56.88 Server **Dump thread - spid = 0, PSS = 0x0000000000000000, EC = 0x0000000000000000 2007-06-08 02:01:56.92 Server ***Stack Dump being sent to H:Microsoft SQL ServerMSSQL.1MSSQLLOGSQLDump0002.txt 2007-06-08 02:01:56.95 Server * ******************************************************************************* 2007-06-08 02:01:56.95 Server * 2007-06-08 02:01:56.95 Server * BEGIN STACK DUMP: 2007-06-08 02:01:56.95 Server * 06/08/07 02:01:56 spid 0 2007-06-08 02:01:56.95 Server * 2007-06-08 02:01:56.95 Server * Non-yielding Resource Monitor 2007-06-08 02:01:56.95 Server * 2007-06-08 02:01:56.95 Server * ******************************************************************************* 2007-06-08 02:01:56.95 Server * ------------------------------------------------------------------------------- 2007-06-08 02:01:56.95 Server * Short Stack Dump 2007-06-08 02:01:57.38 Server Stack Signature for the dump is 0x00000000000002BB 2007-06-08 02:02:02.23 Server External dump process return code 0x20000001. External dump process returned no errors. 2007-06-08 02:02:02.23 Server Resource Monitor (0xc3c) Worker 0x000000008000C1C0 appears to be non-yielding on Node 0. Memory freed: 85936 KB. Approx CPU Used: kernel 125 ms, user 109 ms, Interval: 65000. What can be a problem in this case? Thanks
Open the H:Microsoft SQL ServerMSSQL.1MSSQLLOGSQLDump0002.txt file... you may see which process caused this problem... Most this type of errors cuased by internal sql bugs... MohammedU. Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
Are you using Vista by chance? Do you have any text or image fields query running at the same time? Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
quote:Originally posted by satya Are you using Vista by chance? Do you have any text or image fields query running at the same time? It's a windows 2003 server. I am not sure what was running at that time but i noticed we do have this errors all the time. Wondering if it's related somehow: A fatal error occurred while reading the input stream from the network. The session will be terminated. Message Error: 4014, Severity: 20, State: 8. Also i am openning the case with MS now.
Thats good and it seems that stream error refer to network take help from KBAhttp://support.microsoft.com/kb/812953/ with netmon. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Let me know the findings from PSS results in order to update my KBA [<img src='/community/emoticons/emotion-1.gif' alt='' />].<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</i></font id="size1"></font id="teal"></center>
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by satya</i><br /><br />Let me know the findings from PSS results in order to update my KBA [<img src='/community/emoticons/emotion-1.gif' alt='' />].<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />Hi, this is recommendation from PSS: "Enable Lock Pages in Memory".<br />The actual server is 64-bit Win 2003 server with SS 2005 Ent. 64-bit edition.<br />We did not apply the recommended policy yet.
Any reason for holding back that recommendation? Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
quote:Originally posted by satya Any reason for holding back that recommendation? This is the reason explained by MS: Looks like you are releasing all of the memory pages associated with some object in memory that is being destroyed. You may be facing a situation that the memory is being paged out very heavily and thus taking a long time to call it back from the disk and release it.
Lockin memory page option is recomended even in 64 bit environments... http://blogs.msdn.com/slavao/archive/2005/08/31/458545.aspx http://support.microsoft.com/kb/918483 http://msdn2.microsoft.com/en-us/library/ms190730(SQL.90).aspx MohammedU. Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
I believe they have valid point and you must test and apply the recommendation, as referred above Blogs & KBAs will get you more information Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
ON all my 64bit server "Lock Pages in Memory" enabled... MohammedU. Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
