EXEC master..xp_dirtree @Directory, 10, 1 EXEC master.dbo.xp_cmdshell @Cmd; (@cmd does a rename) EXEC master.dbo.xp_cmdshell @Cmd; (@cmd does a file copy)
We are seeing similar performance issues when connecting to oracle from sql server using the oracle oledb driver from oracle. Did NETMON traces as well...