Post reply

SQL Server data transfer rate

  • April 17, 2015 at 2:55 pm

    #307191

    Hi. A multi data transfer without ETL transforms, just a 1-1 column transfer finishes 940 tables within a 1 hour 30 minute window. The amount of data transferred is 32 GB on a 30Mbps pipe. The transfer moves data from oracle direct to sql server using wherescape red. How is this possible if 1 hour 30 minutes is the estimated time for 20250MB data (20 GB) ? Am I missing something? Thanks in advance. Nick.

  • April 18, 2015 at 4:23 am

    #1791805

    nicklarge1973 (4/17/2015)

    Hi. A multi data transfer without ETL transforms, just a 1-1 column transfer finishes 940 tables within a 1 hour 30 minute window. The amount of data transferred is 32 GB on a 30Mbps pipe. The transfer moves data from oracle direct to sql server using wherescape red. How is this possible if 1 hour 30 minutes is the estimated time for 20250MB data (20 GB) ? Am I missing something? Thanks in advance. Nick.

    Quick thought, translated from bits to bytes, 1 Mps = 125 kilobytes per second, (30 * 125 * 3600) / 2^20 = 12.87 Gb per hour, which suggests 2.5 hours for the transfer of 32 Gb, first thought would be an efficient compression used on the pipe.

    😎

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply