thank you, i will definetely try all your advise, i do have the
DBCC TRACEON (3604)
DBCC TRACEON (1204)
but i do not see any deadlocks in the sql log , by doing some reasearch i read that it would be good to change my remote query timeout configuration from :(this is what i currently have)
remote query timeout (s)02147483647600600
to:
sp_configure 'remote query timeout', 0
reconfigure
would this help?