Maybe someone can asssit.
We have a Windows 2008 R2 SQL 2008 R2 VM running on ESXi5. IBM SVC backend storage. 1GB network.
This is our Datawarehouse SQL Server.
When data loading from our Production Oracle database to the SQL datawarehouse occurs we get extrememly bad network throughput. Roughly 2 to 4 MB/s. Using the Oracle OLEDB driver for the SQL to Oracle connection.
When doing SQL to SQL datatransfers we get 50 to 70MB/s throughput. Also did various test and the network itself does not seem to be an issue, normal file transfers you get the speed expected on a 1Gb network.
Something tells me this have todo with network packet sizes. Has anyone experienced this sort of issue before or can anyone point me in the correct direction of where to start troubleshooting this.