sql server 2005 not sure on service packet windows 2003 server r2 I have interface server that has a service that keeps disconnecting from odbc connection. I tried running odbc trace log and the server ran out of memory. I had to stop the trace because of the memory error. I also rebooted the server too. this issue is still happening. any luck on where to go next?
just 1 interface on one server with access 2003 or access 2007 db and 4 services processing application. the vm it at 22% and the memory doesn't get above 13% when process running. is tarted digging little deeper. it look like sql query could be causing this issue. i check it but it wasn't inner join. I might be looking at the wrong query but not sure.