• 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?