Can someone please help with intitial SQL Profiler filter setup to narrow down the settings and reduce the noise when I'm trying to find out the reason behind socket write error ?

Basically the problem is that certain integration software is dropping xml files along the way from one application to the end application but some go through. There are the errors in the log. After we restarted the sql and app server first two days no messages were dropped.

I need to figure out the possible reason. We will probably have to run the profiler for 24 hours because the error appear only occasionaly so if there is too much data it becomes useless. Any help appreaciated. Thank you.

I/O Error: Connection reset by peer: socket write error
java.sql.SQLException: I/O Error: Connection reset by peer: socket write error
  • 1
    What is the exact version of SQL Server? Can you provide any relevant details from the SQL Server Error Log? – Max Vernon Oct 16 '13 at 2:08
  • I am not aware of SQL Profiler being able to capture socket errors. Might check this post out, references a particular message found in SQL Server ERRORLOG: social.technet.microsoft.com/Forums/sqlserver/en-US/… – Shawn Melton Oct 16 '13 at 5:42
  • Network issues have additional details logged to a ring buffer dependant on version. – Martin Smith Oct 16 '13 at 7:43
  • I think you need to narrow the focus to either the SQL side or the app side. Restarting both of them at once didn't give any feedback about the problem. It's possible the problem is related to the network itself, too. – Jon Seigel Oct 16 '13 at 13:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.