VMware Cloud Community
johanswa
Contributor
Contributor

SQL 2008 R2 Datawarehouse

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.

Reply
0 Kudos
1 Reply
Lace666
Contributor
Contributor

I doubt that you have a packet size problem.

Standard MTU is 1500 bytes, you can setup 9000 bytes "Jumbo" Frames in ESX host, switch and the physical switches and target servers,

but I think jumbo frames will only accelerate transfers of big files.

Reply
0 Kudos