I have an SQL Server that runs an agent job which calls sprocs on another server, and also hits a few file shares.
Every so often the job fails due to time out issues.
I cannot see anything wrong on either sql servers. I contacted the infrastructure team who say they cannot find any intermittent issue( prob cause its intermitent!).
How would i prove this issue exists, and identify the root cause? Has anyone had experience with this?
(just noticed, this forum is for sql server 7/2000. im using sql server 2008. Admins, would you mind moving this to a more appropriate forum please? Thank you)