SQL Server Performance

Fatal error

Discussion in 'SQL Server 2005 General DBA Questions' started by shark68, Jun 11, 2007.

  1. shark68 New Member

    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
  2. MohammedU New Member

    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.
  3. satya Moderator

    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.
  4. shark68 New Member

    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.
  5. satya Moderator

    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.
  6. joechang New Member

    this points to a internal bug
    file a PSS case with MS
  7. satya Moderator

    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>
  8. shark68 New Member

    <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.
  9. satya Moderator

    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.
  10. shark68 New Member

    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.


  11. MohammedU New Member

  12. satya Moderator

    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.
  13. MohammedU New Member

    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.

Share This Page