Tigersgark, I dont think that this would be the case. Machine has experienced more load then that and evn at time no load, but it was fully functional. Morganlefay, there are no hardware issues, as it has been bearing more load then that.
Panic, the application ddoes not have a means for checking its own processes.Ghostmachine, yes we do have auditing enabled nd we did onitored the logs. There was nothing in it other then usual SQL events.
GONEin62nd, the scenario is very much similaar. But in our case, we do not have access to the team who actually developed those modules (vendor). I think that this might be one of the issues.
mohaughn, probablly you are right that this sort of problem cannot be resolved in a forum environment. But it helped me a great deal when it comes to exploring the possibilites and tracing a problem.
Despite, no one talked about sniffing the network traffic on the SQL machine. how about that ??
Thanks
ommy