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.
jdbc:jtds:sqlserver://ASSET-DB-02;instance=test;DatabaseName=MonitorEngine' I/O Error: Connection reset by peer: socket write error java.sql.SQLException: I/O Error: Connection reset by peer: socket write error