Now at 5.11 GB/s SQL backup to Null/3.12 GB/s local backup with I/O Accelerators

Article
10/30/2012

This will be my last update for a while, but I did some more shuffling of the database files among the various PCIE SSD logical drives (HP I/O Accelerators which are HP-OEM Fusion-Io cards). See earlier post for info about the drives. In the latest test, I got up to 5.11 GB/s (5228.521 MB/sec) doing the SQL Backup to NUL device. Given a 40 GbE network card and adequate destinations, that same number should be achievable for a “real” network SQL backup. This is raw throughput. As pointed out earlier, factoring in the database compression efficiency of 40% and typical storage overhead, this is an effective or logical data rate closer to 9.0 GB/s. Also, improved the prior raw 3.05 GB/s to 3.12 GB/s (3195.491 MB/Sec) to local drives including the ioDrives – SQL showed up to 8 GB/s combined read/write throughput spikes – this is significantly above the 6.4 QPI limit, so if any individual QPI bottlenecks are in play, they are not all-encompassing. This time the database was distributed across all of the Duos and for the local backup test it was backed up using the SQL Backup command to all of the Duos along with an additional non-Duo MLC Drive, and 4 SATA SSDs.

SQL command outputs included at end of post for skeptics … Smile . If still not convinced this is possible, check my YouTube video at the 7 minute mark with demo referenced by the 3.05 GB/s post.

This is utilizing 7 Duos spread across Windows-based Raid-0 and Raid-1 logical drives for the database (The ioDrives do not support hardware-based RAID). In theory, RAID-1 is not be much slower than RAID-0 for read, so if all of the files were distributed evenly and read in parallel, the performance should be about twice that (7 * 1500 MB/s per Duo –>10.2 GB/s). Two issues seem to be complicating optimal performance:

1) The RAID-0 implementation from Windows Server – Not sure how it actually does this, but suspect that this involves buffering each data portion from the input drives together and then buffering out – normally this would be good for typical storage, but at these speeds almost any form of buffering just adds another bottleneck, particularly if it is saturating a QPI link. Based on that, better performance will probably be realized by distributing the files across non-Raid volumes, even the RAID-0. The database has dozens of files, but adding a lower level of granularity makes even file distribution more difficult. Depending on how low in the stack the RAID-0 is occurring, it could also be disadvantaged by the PCIE cards from different IOHs connected to different CPUs – can’t figure out which PCIE slots go to which IOHs – figure it is probably every other card or the first half of cards to one IOH and the other set to the other IOH. Each logical read would need to bridge together the I/O from each device which would also involve a non-direct transfer from storage to CPU.

2) SQL Server backup internals – lack of knowledge is hurting me here. Not sure of all details of parallelization, but notice a balancing issue in that if one device has more data to read than another, it slows things down, but not to the degree as on the output balancing. SQL also seems to perform the backup of the various database files in a manner not totally parallel – seemed to see some sequencing around portioned structures but not positive. It also does a final pass on the log, but that is not an issue here since there is noting in the transaction log at this point.

Trying to work through these issues will be time-consuming. Other things are more pressing, so will move onto other things and revisit later unless I stumble upon something in the interim. Thanks for the interest.

RESULTS (Local Backup)

/*------------------------
BACKUP DATABASE [tp_v5_dev] TO
DISK = 'j:\sqlbackup\tp_v5_dev_2012_10_28_j1.bak',
DISK = 'k:\sqlbackup\tp_v5_dev_2012_10_28_k2.bak',
DISK= 'k:\sqlbackup\tp_v5_dev_2012_10_28_k3.bak',
DISK = 'k:\sqlbackup\tp_v5_dev_2012_10_28_k4.bak',
DISK = 'h:\sqlbackup\tp_v5_dev_2012_10_28_h5.bak',
DISK = 'h:\sqlbackup\tp_v5_dev_2012_10_28_h6.bak',
DISK = 'h:\sqlbackup\tp_v5_dev_2012_10_28_h6b.bak',
DISK = 'l:\sqlbackup\tp_v5_dev_2012_10_28_l_7.bak',
DISK = 'l:\sqlbackup\tp_v5_dev_2012_10_28_l_8.bak',
DISK = 'l:\sqlbackup\tp_v5_dev_2012_10_28_l_9.bak',
DISK = 'l:\sqlbackup\tp_v5_dev_2012_10_28_l_10.bak',
DISK = 'l:\sqlbackup\tp_v5_dev_2012_10_28_l_11.bak',
DISK = 'l:\sqlbackup\tp_v5_dev_2012_10_28_l_12.bak',
DISK = 'l:\sqlbackup\tp_v5_dev_2012_10_28_l_13.bak',
DISK = 'l:\sqlbackup\tp_v5_dev_2012_10_28_l_14.bak',
DISK = 'l:\sqlbackup\tp_v5_dev_2012_10_28_l_15.bak',
DISK = 'l:\sqlbackup\tp_v5_dev_2012_10_28_l_16.bak',
DISK = 'l:\sqlbackup\tp_v5_dev_2012_10_28_l_17.bak',
DISK = 'l:\sqlbackup\tp_v5_dev_2012_10_28_l_18.bak',
DISK = 'i:\sqlbackup\tp_v5_dev_2012_10_28_j1_b.bak',
DISK = 'k:\sqlbackup\tp_v5_dev_2012_10_28_k2_b.bak',
DISK= 'k:\sqlbackup\tp_v5_dev_2012_10_28_k3_b.bak',
DISK = 'f:\sqlbackup\tp_v5_dev_2012_10_28_k4_b.bak',
DISK = 'l:\sqlbackup\tp_v5_dev_2012_10_28_h5_b.bak',
DISK = 'h:\sqlbackup\tp_v5_dev_2012_10_28_h6_b.bak',
DISK = 'h:\sqlbackup\tp_v5_dev_2012_10_28_h6b_b.bak',
DISK = 'f:\sqlbackup\tp_v5_dev_2012_10_28_l_7_b.bak',
DISK = 'f:\sqlbackup\tp_v5_dev_2012_10_28_l_8_b.bak',
DISK = 'f:\sqlbackup\tp_v5_dev_2012_10_28_l_9_b.bak',
DISK = 'f:\sqlbackup\tp_v5_dev_2012_10_28_l_10_b.bak',
DISK = 'f:\sqlbackup\tp_v5_dev_2012_10_28_l_11_b.bak',
DISK = 'f:\sqlbackup\tp_v5_dev_2012_10_28_l_12_b.bak',
DISK = 'f:\sqlbackup\tp_v5_dev_2012_10_28_l_13_b.bak',
DISK = 'f:\sqlbackup\tp_v5_dev_2012_10_28_l_14_b.bak',
DISK = 'f:\sqlbackup\tp_v5_dev_2012_10_28_l_15_b.bak',
DISK = 'f:\sqlbackup\tp_v5_dev_2012_10_28_l_16_b.bak',
DISK = 'L:\sqlbackup\tp_v5_dev_2012_10_28_l_17_b.bak',
DISK = 'L:\sqlbackup\tp_v5_dev_2012_10_28_l_18_b.bak',
DISK= 'k:\sqlbackup\tp_v5_dev_2012_10_28_k3_c.bak',
DISK = 'l:\sqlbackup\tp_v5_dev_2012_10_28_k4_c.bak',
DISK = 'f:\sqlbackup\tp_v5_dev_2012_10_28_h5_c.bak',
DISK = 'h:\sqlbackup\tp_v5_dev_2012_10_28_h6b_c.bak',
DISK = 'l:\sqlbackup\tp_v5_dev_2012_10_28_l_7_c.bak',
DISK = 'l:\sqlbackup\tp_v5_dev_2012_10_28_l_8_c.bak',
DISK = 'L:\sqlbackup\tp_v5_dev_2012_10_28_l_9_c.bak',
DISK = 'l:\sqlbackup\tp_v5_dev_2012_10_28_l_10_c.bak',
DISK = 'l:\sqlbackup\tp_v5_dev_2012_10_28_l_11_c.bak',
DISK = 'j:\sqlbackup\tp_v5_dev_2012_10_28_l_12_c.bak',
DISK = 'g:\sqlbackup\tp_v5_dev_2012_10_28_l_13_c.bak',
DISK = 'l:\sqlbackup\tp_v5_dev_2012_10_28_l_14_c.bak',
DISK = 'h:\sqlbackup\tp_v5_dev_2012_10_28_l_15_c.bak',
DISK = 'k:\sqlbackup\tp_v5_dev_2012_10_28_l_16_c.bak',
DISK = 'f:\sqlbackup\tp_v5_dev_2012_10_28_l_17_c.bak',
DISK= 'J:\sqlbackup\tp_v5_dev_2012_10_28_k3_d.bak',
DISK = 'l:\sqlbackup\tp_v5_dev_2012_10_28_k4_d.bak',
DISK = 'F:\sqlbackup\tp_v5_dev_2012_10_28_l_8_d.bak',
DISK = 'l:\sqlbackup\tp_v5_dev_2012_10_28_l_10_d.bak',
DISK = 'H:\sqlbackup\tp_v5_dev_2012_10_28_l_11_d.bak',
DISK = 'H:\sqlbackup\tp_v5_dev_2012_10_28_l_12_d.bak',
DISK = 'K:\sqlbackup\tp_v5_dev_2012_10_28_l_14_d.bak'

-- 'NUL:' -- N'E:\SqlBackup\tp_v5_dev_20120708010002.BAK' WITH NOFORMAT, NOINIT,
-- NAME = N'tp_v5_dev-Full Database Backup',
-- SKIP, NOREWIND, NOUNLOAD,
--disk = 'NUL:'
with STATS = 10, NOINIT, SKIP, -- COPY_ONLY,
BUFFERCOUNT=1536, MAXTRANSFERSIZE=1048576, BLOCKSIZE=65536, NO_COMPRESSION
GO
------------------------*/
10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.
80 percent processed.
90 percent processed.
Processed 25288 pages for database 'tp_v5_dev', file 'TradingOptimizer_v2' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG01_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG02_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG03_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG04_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG05_PageFile01' on file 1.
Processed 17584 pages for database 'tp_v5_dev', file 'History09a' on file 1.
Processed 1680 pages for database 'tp_v5_dev', file 'History09b' on file 1.
Processed 24 pages for database 'tp_v5_dev', file 'History01_01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'History01_02' on file 1.
Processed 24 pages for database 'tp_v5_dev', file 'History02a' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'History02b' on file 1.
Processed 24 pages for database 'tp_v5_dev', file 'History03a' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'History03b' on file 1.
Processed 2736 pages for database 'tp_v5_dev', file 'History04a' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'History04b' on file 1.
Processed 3400 pages for database 'tp_v5_dev', file 'History05a' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'History05b' on file 1.
Processed 5032 pages for database 'tp_v5_dev', file 'History06a' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'History06b' on file 1.
Processed 6936 pages for database 'tp_v5_dev', file 'History07a' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'History07b' on file 1.
Processed 10904 pages for database 'tp_v5_dev', file 'History08a' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'History08b' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG06_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG07_PageFile01' on file 1.
Processed 1814280 pages for database 'tp_v5_dev', file 'HistoryData01' on file 1.
Processed 1674784 pages for database 'tp_v5_dev', file 'HistoryData03' on file 1.
Processed 1657248 pages for database 'tp_v5_dev', file 'HistoryData05' on file 1.
Processed 1182680 pages for database 'tp_v5_dev', file 'LoadData02' on file 1.
Processed 1150464 pages for database 'tp_v5_dev', file 'LoadData04' on file 1.
Processed 1385080 pages for database 'tp_v5_dev', file 'LoadData01' on file 1.
Processed 1230520 pages for database 'tp_v5_dev', file 'LoadData03' on file 1.
Processed 357776 pages for database 'tp_v5_dev', file 'MiscData2' on file 1.
Processed 324864 pages for database 'tp_v5_dev', file 'MiscData1' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG08_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG09_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG10_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG11_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG12_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG13_PageFile01' on file 1.
Processed 5112 pages for database 'tp_v5_dev', file 'History10_01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'History10_02' on file 1.
Processed 56 pages for database 'tp_v5_dev', file 'Loadfg00a' on file 1.
Processed 56 pages for database 'tp_v5_dev', file 'Loadfg00b' on file 1.
Processed 32608 pages for database 'tp_v5_dev', file 'Loadfg01a' on file 1.
Processed 42000 pages for database 'tp_v5_dev', file 'Loadfg01b' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG14_PageFile01' on file 1.
Processed 5168 pages for database 'tp_v5_dev', file 'History09b1' on file 1.
Processed 464 pages for database 'tp_v5_dev', file 'History09b2' on file 1.
Processed 40 pages for database 'tp_v5_dev', file 'History09c1' on file 1.
Processed 5688 pages for database 'tp_v5_dev', file 'History09c2' on file 1.
Processed 40 pages for database 'tp_v5_dev', file 'History09d1' on file 1.
Processed 5760 pages for database 'tp_v5_dev', file 'History09d2' on file 1.
Processed 6488 pages for database 'tp_v5_dev', file 'History10a1' on file 1.
Processed 432 pages for database 'tp_v5_dev', file 'History10a2' on file 1.
Processed 8784 pages for database 'tp_v5_dev', file 'History10b1' on file 1.
Processed 16 pages for database 'tp_v5_dev', file 'History10b2' on file 1.
Processed 20240 pages for database 'tp_v5_dev', file 'History10c2' on file 1.
Processed 55416 pages for database 'tp_v5_dev', file 'History10d2' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'Archive01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'Archive02' on file 1.
Processed 40 pages for database 'tp_v5_dev', file 'Archive03' on file 1.
Processed 31888 pages for database 'tp_v5_dev', file 'Loadfg02a' on file 1.
Processed 41488 pages for database 'tp_v5_dev', file 'Loadfg02b' on file 1.
Processed 43032 pages for database 'tp_v5_dev', file 'Loadfg03a' on file 1.
Processed 43448 pages for database 'tp_v5_dev', file 'Loadfg03b' on file 1.
Processed 40976 pages for database 'tp_v5_dev', file 'Loadfg04a' on file 1.
Processed 41248 pages for database 'tp_v5_dev', file 'Loadfg04b' on file 1.
Processed 34376 pages for database 'tp_v5_dev', file 'Loadfg05a' on file 1.
Processed 47120 pages for database 'tp_v5_dev', file 'Loadfg05b' on file 1.
Processed 44816 pages for database 'tp_v5_dev', file 'Loadfg06a' on file 1.
Processed 45072 pages for database 'tp_v5_dev', file 'Loadfg06b' on file 1.
Processed 44056 pages for database 'tp_v5_dev', file 'Loadfg07a' on file 1.
Processed 44344 pages for database 'tp_v5_dev', file 'Loadfg07b' on file 1.
Processed 41976 pages for database 'tp_v5_dev', file 'Loadfg08a' on file 1.
Processed 48648 pages for database 'tp_v5_dev', file 'Loadfg08b' on file 1.
Processed 50696 pages for database 'tp_v5_dev', file 'Loadfg09a' on file 1.
Processed 50696 pages for database 'tp_v5_dev', file 'Loadfg09b' on file 1.
Processed 51208 pages for database 'tp_v5_dev', file 'Loadfg10a' on file 1.
Processed 55432 pages for database 'tp_v5_dev', file 'Loadfg10b' on file 1.
Processed 56 pages for database 'tp_v5_dev', file 'Loadfg11d' on file 1.
Processed 46096 pages for database 'tp_v5_dev', file 'Loadfg11a' on file 1.
Processed 49672 pages for database 'tp_v5_dev', file 'Loadfg11b' on file 1.
Processed 46864 pages for database 'tp_v5_dev', file 'Loadfg12a' on file 1.
Processed 60424 pages for database 'tp_v5_dev', file 'Loadfg12b' on file 1.
Processed 41496 pages for database 'tp_v5_dev', file 'Loadfg13a' on file 1.
Processed 50808 pages for database 'tp_v5_dev', file 'Loadfg13b' on file 1.
Processed 35872 pages for database 'tp_v5_dev', file 'Loadfg14a' on file 1.
Processed 45192 pages for database 'tp_v5_dev', file 'Loadfg14b' on file 1.
Processed 45080 pages for database 'tp_v5_dev', file 'Loadfg15a' on file 1.
Processed 54352 pages for database 'tp_v5_dev', file 'Loadfg15b' on file 1.
Processed 39664 pages for database 'tp_v5_dev', file 'Loadfg16a' on file 1.
Processed 53256 pages for database 'tp_v5_dev', file 'Loadfg16b' on file 1.
Processed 39624 pages for database 'tp_v5_dev', file 'Loadfg17a' on file 1.
Processed 53256 pages for database 'tp_v5_dev', file 'Loadfg17b' on file 1.
Processed 41328 pages for database 'tp_v5_dev', file 'Loadfg18a' on file 1.
Processed 54784 pages for database 'tp_v5_dev', file 'Loadfg18b' on file 1.
Processed 116240 pages for database 'tp_v5_dev', file 'Loadfg19a' on file 1.
Processed 119688 pages for database 'tp_v5_dev', file 'Loadfg19b' on file 1.
Processed 131088 pages for database 'tp_v5_dev', file 'Loadfg20a' on file 1.
Processed 91656 pages for database 'tp_v5_dev', file 'Loadfg20b' on file 1.
Processed 71296 pages for database 'tp_v5_dev', file 'Loadfg21a' on file 1.
Processed 93704 pages for database 'tp_v5_dev', file 'Loadfg21b' on file 1.
Processed 74768 pages for database 'tp_v5_dev', file 'Loadfg22a' on file 1.
Processed 96832 pages for database 'tp_v5_dev', file 'Loadfg22b' on file 1.
Processed 71224 pages for database 'tp_v5_dev', file 'Loadfg23a' on file 1.
Processed 93704 pages for database 'tp_v5_dev', file 'Loadfg23b' on file 1.
Processed 76200 pages for database 'tp_v5_dev', file 'Loadfg24a' on file 1.
Processed 98312 pages for database 'tp_v5_dev', file 'Loadfg24b' on file 1.
Processed 64 pages for database 'tp_v5_dev', file 'SimIndex01' on file 1.
Processed 48 pages for database 'tp_v5_dev', file 'SimIndex02' on file 1.
Processed 48 pages for database 'tp_v5_dev', file 'SimIndex04' on file 1.
Processed 48 pages for database 'tp_v5_dev', file 'SimIndex05' on file 1.
Processed 16 pages for database 'tp_v5_dev', file 'Sim42' on file 1.
Processed 65472 pages for database 'tp_v5_dev', file 'History11a1' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'History11a2' on file 1.
Processed 64 pages for database 'tp_v5_dev', file 'Intraday03' on file 1.
Processed 64 pages for database 'tp_v5_dev', file 'Intraday04' on file 1.
Processed 64744 pages for database 'tp_v5_dev', file 'History11b1' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'History11b2' on file 1.
Processed 73344 pages for database 'tp_v5_dev', file 'History11c2' on file 1.
Processed 16 pages for database 'tp_v5_dev', file 'History11d1' on file 1.
Processed 34704 pages for database 'tp_v5_dev', file 'History11d2' on file 1.
Processed 16 pages for database 'tp_v5_dev', file 'History12a1' on file 1.
Processed 144 pages for database 'tp_v5_dev', file 'History12a2' on file 1.
Processed 16 pages for database 'tp_v5_dev', file 'History12b1' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'History12b2' on file 1.
Processed 16 pages for database 'tp_v5_dev', file 'History12c1' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'History12c2' on file 1.
Processed 16 pages for database 'tp_v5_dev', file 'History12d1' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'History12d2' on file 1.
Processed 94912 pages for database 'tp_v5_dev', file 'loadfg25a' on file 1.
Processed 105168 pages for database 'tp_v5_dev', file 'loadfg25b' on file 1.
Processed 112320 pages for database 'tp_v5_dev', file 'loadfg26a' on file 1.
Processed 114832 pages for database 'tp_v5_dev', file 'loadfg26b' on file 1.
Processed 129792 pages for database 'tp_v5_dev', file 'loadfg27a' on file 1.
Processed 145840 pages for database 'tp_v5_dev', file 'loadfg27b' on file 1.
Processed 114000 pages for database 'tp_v5_dev', file 'loadfg28a' on file 1.
Processed 115704 pages for database 'tp_v5_dev', file 'loadfg28b' on file 1.
Processed 114888 pages for database 'tp_v5_dev', file 'loadfg29a' on file 1.
Processed 116640 pages for database 'tp_v5_dev', file 'loadfg29b' on file 1.
Processed 127136 pages for database 'tp_v5_dev', file 'loadfg30a' on file 1.
Processed 137128 pages for database 'tp_v5_dev', file 'loadfg30b' on file 1.
Processed 114208 pages for database 'tp_v5_dev', file 'loadfg31a' on file 1.
Processed 114888 pages for database 'tp_v5_dev', file 'loadfg31b' on file 1.
Processed 130200 pages for database 'tp_v5_dev', file 'loadfg32a' on file 1.
Processed 139536 pages for database 'tp_v5_dev', file 'loadfg32b' on file 1.
Processed 114648 pages for database 'tp_v5_dev', file 'loadfg33a' on file 1.
Processed 126072 pages for database 'tp_v5_dev', file 'loadfg33b' on file 1.
Processed 113184 pages for database 'tp_v5_dev', file 'loadfg34a' on file 1.
Processed 122184 pages for database 'tp_v5_dev', file 'loadfg34b' on file 1.
Processed 105432 pages for database 'tp_v5_dev', file 'loadfg35a' on file 1.
Processed 126624 pages for database 'tp_v5_dev', file 'loadfg35b' on file 1.
Processed 111752 pages for database 'tp_v5_dev', file 'loadfg36a' on file 1.
Processed 121128 pages for database 'tp_v5_dev', file 'loadfg36b' on file 1.
Processed 150920 pages for database 'tp_v5_dev', file 'Loadfg37a' on file 1.
Processed 64000 pages for database 'tp_v5_dev', file 'Loadfg37b' on file 1.
Processed 113976 pages for database 'tp_v5_dev', file 'load38_01' on file 1.
Processed 102400 pages for database 'tp_v5_dev', file 'load38_02' on file 1.
Processed 121368 pages for database 'tp_v5_dev', file 'load39_01' on file 1.
Processed 115200 pages for database 'tp_v5_dev', file 'load39_02' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG15_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG16_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG17_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG18_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG19_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG20_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG21_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG22_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG23_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG24_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG25_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG26_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG27_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG28_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG29_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG30_PageFile01' on file 1.
Processed 44448 pages for database 'tp_v5_dev', file 'Interval_01' on file 1.
Processed 60544 pages for database 'tp_v5_dev', file 'Interval_fg01a' on file 1.
Processed 65752 pages for database 'tp_v5_dev', file 'Interval_fg01b' on file 1.
Processed 71600 pages for database 'tp_v5_dev', file 'Interval_fg01c' on file 1.
Processed 32168 pages for database 'tp_v5_dev', file 'Interval_02' on file 1.
Processed 58416 pages for database 'tp_v5_dev', file 'Interval_fg02a' on file 1.
Processed 58336 pages for database 'tp_v5_dev', file 'Interval_fg02b' on file 1.
Processed 75624 pages for database 'tp_v5_dev', file 'Interval_fg02c' on file 1.
Processed 35632 pages for database 'tp_v5_dev', file 'Interval_03' on file 1.
Processed 64488 pages for database 'tp_v5_dev', file 'Interval_fg03a' on file 1.
Processed 73336 pages for database 'tp_v5_dev', file 'Interval_fg03b' on file 1.
Processed 73776 pages for database 'tp_v5_dev', file 'Interval_fg03c' on file 1.
Processed 11456 pages for database 'tp_v5_dev', file 'Interval_04' on file 1.
Processed 30584 pages for database 'tp_v5_dev', file 'Interval_fg04a' on file 1.
Processed 30392 pages for database 'tp_v5_dev', file 'Interval_fg04b' on file 1.
Processed 31688 pages for database 'tp_v5_dev', file 'Interval_fg04c' on file 1.
Processed 38992 pages for database 'tp_v5_dev', file 'Interval_fg05a' on file 1.
Processed 38896 pages for database 'tp_v5_dev', file 'Interval_fg05b' on file 1.
Processed 39304 pages for database 'tp_v5_dev', file 'Interval_fg05c' on file 1.
Processed 22016 pages for database 'tp_v5_dev', file 'Interval_06' on file 1.
Processed 38704 pages for database 'tp_v5_dev', file 'Interval_fg06a' on file 1.
Processed 35408 pages for database 'tp_v5_dev', file 'Interval_fg06b' on file 1.
Processed 34840 pages for database 'tp_v5_dev', file 'Interval_fg06c' on file 1.
Processed 45920 pages for database 'tp_v5_dev', file 'Interval_fg07a' on file 1.
Processed 47080 pages for database 'tp_v5_dev', file 'Interval_fg07b' on file 1.
Processed 52416 pages for database 'tp_v5_dev', file 'Interval_fg07c' on file 1.
Processed 55120 pages for database 'tp_v5_dev', file 'Interval_fg08a' on file 1.
Processed 60064 pages for database 'tp_v5_dev', file 'Interval_fg08b' on file 1.
Processed 61808 pages for database 'tp_v5_dev', file 'Interval_fg08c' on file 1.
Processed 32392 pages for database 'tp_v5_dev', file 'Interval_09' on file 1.
Processed 64872 pages for database 'tp_v5_dev', file 'Interval_fg09a' on file 1.
Processed 63080 pages for database 'tp_v5_dev', file 'Interval_fg09b' on file 1.
Processed 60840 pages for database 'tp_v5_dev', file 'Interval_fg09c' on file 1.
Processed 13992 pages for database 'tp_v5_dev', file 'Interval_10' on file 1.
Processed 16272 pages for database 'tp_v5_dev', file 'Interval_fg10a' on file 1.
Processed 13352 pages for database 'tp_v5_dev', file 'Interval_fg10b' on file 1.
Processed 27160 pages for database 'tp_v5_dev', file 'Interval_fg10c' on file 1.
Processed 14720 pages for database 'tp_v5_dev', file 'Interval_11' on file 1.
Processed 16680 pages for database 'tp_v5_dev', file 'Interval_fg11a' on file 1.
Processed 28184 pages for database 'tp_v5_dev', file 'Interval_fg11b' on file 1.
Processed 13784 pages for database 'tp_v5_dev', file 'Interval_fg11c' on file 1.
Processed 15744 pages for database 'tp_v5_dev', file 'Interval_12' on file 1.
Processed 15040 pages for database 'tp_v5_dev', file 'Interval_fg12a' on file 1.
Processed 13936 pages for database 'tp_v5_dev', file 'Interval_fg12b' on file 1.
Processed 29944 pages for database 'tp_v5_dev', file 'Interval_fg12c' on file 1.
Processed 13200 pages for database 'tp_v5_dev', file 'Interval_13' on file 1.
Processed 23584 pages for database 'tp_v5_dev', file 'Interval_fg13a' on file 1.
Processed 12904 pages for database 'tp_v5_dev', file 'Interval_fg13b' on file 1.
Processed 26776 pages for database 'tp_v5_dev', file 'Interval_fg13c' on file 1.
Processed 15296 pages for database 'tp_v5_dev', file 'Interval_14' on file 1.
Processed 17840 pages for database 'tp_v5_dev', file 'Interval_fg14a' on file 1.
Processed 12320 pages for database 'tp_v5_dev', file 'Interval_fg14b' on file 1.
Processed 28320 pages for database 'tp_v5_dev', file 'Interval_fg14c' on file 1.
Processed 18400 pages for database 'tp_v5_dev', file 'Interval_fg15a' on file 1.
Processed 28928 pages for database 'tp_v5_dev', file 'Interval_fg15b' on file 1.
Processed 30744 pages for database 'tp_v5_dev', file 'Interval_fg15c' on file 1.
Processed 30088 pages for database 'tp_v5_dev', file 'Interval_fg16a' on file 1.
Processed 16184 pages for database 'tp_v5_dev', file 'Interval_fg16b' on file 1.
Processed 36504 pages for database 'tp_v5_dev', file 'Interval_fg16c' on file 1.
Processed 18968 pages for database 'tp_v5_dev', file 'Interval_17' on file 1.
Processed 14592 pages for database 'tp_v5_dev', file 'Interval_fg17a' on file 1.
Processed 30032 pages for database 'tp_v5_dev', file 'Interval_fg17b' on file 1.
Processed 31888 pages for database 'tp_v5_dev', file 'Interval_fg17c' on file 1.
Processed 22392 pages for database 'tp_v5_dev', file 'Interval_fg18a' on file 1.
Processed 30136 pages for database 'tp_v5_dev', file 'Interval_fg18b' on file 1.
Processed 37224 pages for database 'tp_v5_dev', file 'Interval_fg18c' on file 1.
Processed 33616 pages for database 'tp_v5_dev', file 'Interval_fg19a' on file 1.
Processed 30024 pages for database 'tp_v5_dev', file 'Interval_fg19b' on file 1.
Processed 29864 pages for database 'tp_v5_dev', file 'Interval_fg19c' on file 1.
Processed 36248 pages for database 'tp_v5_dev', file 'Interval_20a' on file 1.
Processed 27616 pages for database 'tp_v5_dev', file 'Interval_20b' on file 1.
Processed 27376 pages for database 'tp_v5_dev', file 'Interval_20c' on file 1.
Processed 12632 pages for database 'tp_v5_dev', file 'Interval_21' on file 1.
Processed 13080 pages for database 'tp_v5_dev', file 'Interval_fg21a' on file 1.
Processed 24608 pages for database 'tp_v5_dev', file 'Interval_fg21b' on file 1.
Processed 24288 pages for database 'tp_v5_dev', file 'Interval_fg21c' on file 1.
Processed 736 pages for database 'tp_v5_dev', file 'Interval_22b' on file 1.
Processed 992 pages for database 'tp_v5_dev', file 'Interval_fg22a' on file 1.
Processed 1032 pages for database 'tp_v5_dev', file 'Interval_fg22b' on file 1.
Processed 1088 pages for database 'tp_v5_dev', file 'Interval_fg22c' on file 1.
Processed 40 pages for database 'tp_v5_dev', file 'MatchType_Fg01_File01' on file 1.
Processed 40 pages for database 'tp_v5_dev', file 'MatchType_Fg02_File01' on file 1.
Processed 40 pages for database 'tp_v5_dev', file 'MatchType_Fg03_File01' on file 1.
Processed 40 pages for database 'tp_v5_dev', file 'MatchType_Fg04_File01' on file 1.
Processed 40 pages for database 'tp_v5_dev', file 'MatchType_Fg05_File01' on file 1.
Processed 40 pages for database 'tp_v5_dev', file 'MatchType_Fg06_File01' on file 1.
Processed 40 pages for database 'tp_v5_dev', file 'MatchType_Fg07_File01' on file 1.
Processed 40 pages for database 'tp_v5_dev', file 'MatchType_Fg08_File01' on file 1.
Processed 40 pages for database 'tp_v5_dev', file 'MatchType_Fg09_File01' on file 1.
Processed 40 pages for database 'tp_v5_dev', file 'MatchType_Fg10_File01' on file 1.
Processed 768 pages for database 'tp_v5_dev', file 'Interval_fg23a' on file 1.
Processed 784 pages for database 'tp_v5_dev', file 'Interval_fg23b' on file 1.
Processed 784 pages for database 'tp_v5_dev', file 'Interval_fg23c' on file 1.
Processed 838952 pages for database 'tp_v5_dev', file 'Interval_fg24a' on file 1.
Processed 732784 pages for database 'tp_v5_dev', file 'Interval_fg24b' on file 1.
Processed 804256 pages for database 'tp_v5_dev', file 'Interval_fg24c' on file 1.
Processed 520 pages for database 'tp_v5_dev', file 'Interval_fg25a' on file 1.
Processed 520 pages for database 'tp_v5_dev', file 'Interval_fg25b' on file 1.
Processed 520 pages for database 'tp_v5_dev', file 'Interval_fg25c' on file 1.
Processed 219528 pages for database 'tp_v5_dev', file 'Load40_01' on file 1.
Processed 156968 pages for database 'tp_v5_dev', file 'Load41_01' on file 1.
Processed 169880 pages for database 'tp_v5_dev', file 'Load42_01' on file 1.
Processed 860640 pages for database 'tp_v5_dev', file 'Load43_01' on file 1.
Processed 16 pages for database 'tp_v5_dev', file 'Load44_01' on file 1.
Processed 16 pages for database 'tp_v5_dev', file 'Load45_01' on file 1.
Processed 16 pages for database 'tp_v5_dev', file 'Load46_01' on file 1.
Processed 16 pages for database 'tp_v5_dev', file 'Load47_01' on file 1.
Processed 16 pages for database 'tp_v5_dev', file 'Load48_01' on file 1.
100 percent processed.
Processed 0 pages for database 'tp_v5_dev', file 'TradingOptimizer_v2_log' on file 1.
Processed 2 pages for database 'tp_v5_dev', file 'TradingOptimizerLog2' on file 1.
Processed 0 pages for database 'tp_v5_dev', file 'TradingOptimizerLog3' on file 1.
BACKUP DATABASE successfully processed 23884890 pages in 58.395 seconds (3195.491 MB/sec).

RESUTS (Backup TO NUL – forgot to include the query in the output)

10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.
80 percent processed.
90 percent processed.
Processed 25288 pages for database 'tp_v5_dev', file 'TradingOptimizer_v2' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG01_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG02_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG03_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG04_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG05_PageFile01' on file 1.
Processed 17584 pages for database 'tp_v5_dev', file 'History09a' on file 1.
Processed 1680 pages for database 'tp_v5_dev', file 'History09b' on file 1.
Processed 24 pages for database 'tp_v5_dev', file 'History01_01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'History01_02' on file 1.
Processed 24 pages for database 'tp_v5_dev', file 'History02a' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'History02b' on file 1.
Processed 24 pages for database 'tp_v5_dev', file 'History03a' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'History03b' on file 1.
Processed 2736 pages for database 'tp_v5_dev', file 'History04a' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'History04b' on file 1.
Processed 3400 pages for database 'tp_v5_dev', file 'History05a' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'History05b' on file 1.
Processed 5032 pages for database 'tp_v5_dev', file 'History06a' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'History06b' on file 1.
Processed 6936 pages for database 'tp_v5_dev', file 'History07a' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'History07b' on file 1.
Processed 10904 pages for database 'tp_v5_dev', file 'History08a' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'History08b' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG06_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG07_PageFile01' on file 1.
Processed 1814280 pages for database 'tp_v5_dev', file 'HistoryData01' on file 1.
Processed 1674784 pages for database 'tp_v5_dev', file 'HistoryData03' on file 1.
Processed 1657248 pages for database 'tp_v5_dev', file 'HistoryData05' on file 1.
Processed 1182680 pages for database 'tp_v5_dev', file 'LoadData02' on file 1.
Processed 1150464 pages for database 'tp_v5_dev', file 'LoadData04' on file 1.
Processed 1385080 pages for database 'tp_v5_dev', file 'LoadData01' on file 1.
Processed 1230520 pages for database 'tp_v5_dev', file 'LoadData03' on file 1.
Processed 357776 pages for database 'tp_v5_dev', file 'MiscData2' on file 1.
Processed 324864 pages for database 'tp_v5_dev', file 'MiscData1' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG08_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG09_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG10_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG11_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG12_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG13_PageFile01' on file 1.
Processed 5112 pages for database 'tp_v5_dev', file 'History10_01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'History10_02' on file 1.
Processed 56 pages for database 'tp_v5_dev', file 'Loadfg00a' on file 1.
Processed 56 pages for database 'tp_v5_dev', file 'Loadfg00b' on file 1.
Processed 32608 pages for database 'tp_v5_dev', file 'Loadfg01a' on file 1.
Processed 42000 pages for database 'tp_v5_dev', file 'Loadfg01b' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG14_PageFile01' on file 1.
Processed 5168 pages for database 'tp_v5_dev', file 'History09b1' on file 1.
Processed 464 pages for database 'tp_v5_dev', file 'History09b2' on file 1.
Processed 40 pages for database 'tp_v5_dev', file 'History09c1' on file 1.
Processed 5688 pages for database 'tp_v5_dev', file 'History09c2' on file 1.
Processed 40 pages for database 'tp_v5_dev', file 'History09d1' on file 1.
Processed 5760 pages for database 'tp_v5_dev', file 'History09d2' on file 1.
Processed 6488 pages for database 'tp_v5_dev', file 'History10a1' on file 1.
Processed 432 pages for database 'tp_v5_dev', file 'History10a2' on file 1.
Processed 8784 pages for database 'tp_v5_dev', file 'History10b1' on file 1.
Processed 16 pages for database 'tp_v5_dev', file 'History10b2' on file 1.
Processed 20240 pages for database 'tp_v5_dev', file 'History10c2' on file 1.
Processed 55416 pages for database 'tp_v5_dev', file 'History10d2' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'Archive01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'Archive02' on file 1.
Processed 40 pages for database 'tp_v5_dev', file 'Archive03' on file 1.
Processed 31888 pages for database 'tp_v5_dev', file 'Loadfg02a' on file 1.
Processed 41488 pages for database 'tp_v5_dev', file 'Loadfg02b' on file 1.
Processed 43032 pages for database 'tp_v5_dev', file 'Loadfg03a' on file 1.
Processed 43448 pages for database 'tp_v5_dev', file 'Loadfg03b' on file 1.
Processed 40976 pages for database 'tp_v5_dev', file 'Loadfg04a' on file 1.
Processed 41248 pages for database 'tp_v5_dev', file 'Loadfg04b' on file 1.
Processed 34376 pages for database 'tp_v5_dev', file 'Loadfg05a' on file 1.
Processed 47120 pages for database 'tp_v5_dev', file 'Loadfg05b' on file 1.
Processed 44816 pages for database 'tp_v5_dev', file 'Loadfg06a' on file 1.
Processed 45072 pages for database 'tp_v5_dev', file 'Loadfg06b' on file 1.
Processed 44056 pages for database 'tp_v5_dev', file 'Loadfg07a' on file 1.
Processed 44344 pages for database 'tp_v5_dev', file 'Loadfg07b' on file 1.
Processed 41976 pages for database 'tp_v5_dev', file 'Loadfg08a' on file 1.
Processed 48648 pages for database 'tp_v5_dev', file 'Loadfg08b' on file 1.
Processed 50696 pages for database 'tp_v5_dev', file 'Loadfg09a' on file 1.
Processed 50696 pages for database 'tp_v5_dev', file 'Loadfg09b' on file 1.
Processed 51208 pages for database 'tp_v5_dev', file 'Loadfg10a' on file 1.
Processed 55432 pages for database 'tp_v5_dev', file 'Loadfg10b' on file 1.
Processed 56 pages for database 'tp_v5_dev', file 'Loadfg11d' on file 1.
Processed 46096 pages for database 'tp_v5_dev', file 'Loadfg11a' on file 1.
Processed 49672 pages for database 'tp_v5_dev', file 'Loadfg11b' on file 1.
Processed 46864 pages for database 'tp_v5_dev', file 'Loadfg12a' on file 1.
Processed 60424 pages for database 'tp_v5_dev', file 'Loadfg12b' on file 1.
Processed 41496 pages for database 'tp_v5_dev', file 'Loadfg13a' on file 1.
Processed 50808 pages for database 'tp_v5_dev', file 'Loadfg13b' on file 1.
Processed 35872 pages for database 'tp_v5_dev', file 'Loadfg14a' on file 1.
Processed 45192 pages for database 'tp_v5_dev', file 'Loadfg14b' on file 1.
Processed 45080 pages for database 'tp_v5_dev', file 'Loadfg15a' on file 1.
Processed 54352 pages for database 'tp_v5_dev', file 'Loadfg15b' on file 1.
Processed 39664 pages for database 'tp_v5_dev', file 'Loadfg16a' on file 1.
Processed 53256 pages for database 'tp_v5_dev', file 'Loadfg16b' on file 1.
Processed 39624 pages for database 'tp_v5_dev', file 'Loadfg17a' on file 1.
Processed 53256 pages for database 'tp_v5_dev', file 'Loadfg17b' on file 1.
Processed 41328 pages for database 'tp_v5_dev', file 'Loadfg18a' on file 1.
Processed 54784 pages for database 'tp_v5_dev', file 'Loadfg18b' on file 1.
Processed 116240 pages for database 'tp_v5_dev', file 'Loadfg19a' on file 1.
Processed 119688 pages for database 'tp_v5_dev', file 'Loadfg19b' on file 1.
Processed 131088 pages for database 'tp_v5_dev', file 'Loadfg20a' on file 1.
Processed 91656 pages for database 'tp_v5_dev', file 'Loadfg20b' on file 1.
Processed 71296 pages for database 'tp_v5_dev', file 'Loadfg21a' on file 1.
Processed 93704 pages for database 'tp_v5_dev', file 'Loadfg21b' on file 1.
Processed 74768 pages for database 'tp_v5_dev', file 'Loadfg22a' on file 1.
Processed 96832 pages for database 'tp_v5_dev', file 'Loadfg22b' on file 1.
Processed 71224 pages for database 'tp_v5_dev', file 'Loadfg23a' on file 1.
Processed 93704 pages for database 'tp_v5_dev', file 'Loadfg23b' on file 1.
Processed 76200 pages for database 'tp_v5_dev', file 'Loadfg24a' on file 1.
Processed 98312 pages for database 'tp_v5_dev', file 'Loadfg24b' on file 1.
Processed 64 pages for database 'tp_v5_dev', file 'SimIndex01' on file 1.
Processed 48 pages for database 'tp_v5_dev', file 'SimIndex02' on file 1.
Processed 48 pages for database 'tp_v5_dev', file 'SimIndex04' on file 1.
Processed 48 pages for database 'tp_v5_dev', file 'SimIndex05' on file 1.
Processed 16 pages for database 'tp_v5_dev', file 'Sim42' on file 1.
Processed 65472 pages for database 'tp_v5_dev', file 'History11a1' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'History11a2' on file 1.
Processed 64 pages for database 'tp_v5_dev', file 'Intraday03' on file 1.
Processed 64 pages for database 'tp_v5_dev', file 'Intraday04' on file 1.
Processed 64744 pages for database 'tp_v5_dev', file 'History11b1' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'History11b2' on file 1.
Processed 73344 pages for database 'tp_v5_dev', file 'History11c2' on file 1.
Processed 16 pages for database 'tp_v5_dev', file 'History11d1' on file 1.
Processed 34704 pages for database 'tp_v5_dev', file 'History11d2' on file 1.
Processed 16 pages for database 'tp_v5_dev', file 'History12a1' on file 1.
Processed 144 pages for database 'tp_v5_dev', file 'History12a2' on file 1.
Processed 16 pages for database 'tp_v5_dev', file 'History12b1' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'History12b2' on file 1.
Processed 16 pages for database 'tp_v5_dev', file 'History12c1' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'History12c2' on file 1.
Processed 16 pages for database 'tp_v5_dev', file 'History12d1' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'History12d2' on file 1.
Processed 94912 pages for database 'tp_v5_dev', file 'loadfg25a' on file 1.
Processed 105168 pages for database 'tp_v5_dev', file 'loadfg25b' on file 1.
Processed 112320 pages for database 'tp_v5_dev', file 'loadfg26a' on file 1.
Processed 114832 pages for database 'tp_v5_dev', file 'loadfg26b' on file 1.
Processed 129792 pages for database 'tp_v5_dev', file 'loadfg27a' on file 1.
Processed 145840 pages for database 'tp_v5_dev', file 'loadfg27b' on file 1.
Processed 114000 pages for database 'tp_v5_dev', file 'loadfg28a' on file 1.
Processed 115704 pages for database 'tp_v5_dev', file 'loadfg28b' on file 1.
Processed 114888 pages for database 'tp_v5_dev', file 'loadfg29a' on file 1.
Processed 116640 pages for database 'tp_v5_dev', file 'loadfg29b' on file 1.
Processed 127136 pages for database 'tp_v5_dev', file 'loadfg30a' on file 1.
Processed 137128 pages for database 'tp_v5_dev', file 'loadfg30b' on file 1.
Processed 114208 pages for database 'tp_v5_dev', file 'loadfg31a' on file 1.
Processed 114888 pages for database 'tp_v5_dev', file 'loadfg31b' on file 1.
Processed 130200 pages for database 'tp_v5_dev', file 'loadfg32a' on file 1.
Processed 139536 pages for database 'tp_v5_dev', file 'loadfg32b' on file 1.
Processed 114648 pages for database 'tp_v5_dev', file 'loadfg33a' on file 1.
Processed 126072 pages for database 'tp_v5_dev', file 'loadfg33b' on file 1.
Processed 113184 pages for database 'tp_v5_dev', file 'loadfg34a' on file 1.
Processed 122184 pages for database 'tp_v5_dev', file 'loadfg34b' on file 1.
Processed 105432 pages for database 'tp_v5_dev', file 'loadfg35a' on file 1.
Processed 126624 pages for database 'tp_v5_dev', file 'loadfg35b' on file 1.
Processed 111752 pages for database 'tp_v5_dev', file 'loadfg36a' on file 1.
Processed 121128 pages for database 'tp_v5_dev', file 'loadfg36b' on file 1.
Processed 150920 pages for database 'tp_v5_dev', file 'Loadfg37a' on file 1.
Processed 64000 pages for database 'tp_v5_dev', file 'Loadfg37b' on file 1.
Processed 113976 pages for database 'tp_v5_dev', file 'load38_01' on file 1.
Processed 102400 pages for database 'tp_v5_dev', file 'load38_02' on file 1.
Processed 121368 pages for database 'tp_v5_dev', file 'load39_01' on file 1.
Processed 115200 pages for database 'tp_v5_dev', file 'load39_02' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG15_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG16_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG17_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG18_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG19_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG20_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG21_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG22_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG23_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG24_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG25_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG26_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG27_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG28_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG29_PageFile01' on file 1.
Processed 32 pages for database 'tp_v5_dev', file 'PageField_FG30_PageFile01' on file 1.
Processed 44448 pages for database 'tp_v5_dev', file 'Interval_01' on file 1.
Processed 60544 pages for database 'tp_v5_dev', file 'Interval_fg01a' on file 1.
Processed 65752 pages for database 'tp_v5_dev', file 'Interval_fg01b' on file 1.
Processed 71600 pages for database 'tp_v5_dev', file 'Interval_fg01c' on file 1.
Processed 32168 pages for database 'tp_v5_dev', file 'Interval_02' on file 1.
Processed 58416 pages for database 'tp_v5_dev', file 'Interval_fg02a' on file 1.
Processed 58336 pages for database 'tp_v5_dev', file 'Interval_fg02b' on file 1.
Processed 75624 pages for database 'tp_v5_dev', file 'Interval_fg02c' on file 1.
Processed 35632 pages for database 'tp_v5_dev', file 'Interval_03' on file 1.
Processed 64488 pages for database 'tp_v5_dev', file 'Interval_fg03a' on file 1.
Processed 73336 pages for database 'tp_v5_dev', file 'Interval_fg03b' on file 1.
Processed 73776 pages for database 'tp_v5_dev', file 'Interval_fg03c' on file 1.
Processed 11456 pages for database 'tp_v5_dev', file 'Interval_04' on file 1.
Processed 30584 pages for database 'tp_v5_dev', file 'Interval_fg04a' on file 1.
Processed 30392 pages for database 'tp_v5_dev', file 'Interval_fg04b' on file 1.
Processed 31688 pages for database 'tp_v5_dev', file 'Interval_fg04c' on file 1.
Processed 38992 pages for database 'tp_v5_dev', file 'Interval_fg05a' on file 1.
Processed 38896 pages for database 'tp_v5_dev', file 'Interval_fg05b' on file 1.
Processed 39304 pages for database 'tp_v5_dev', file 'Interval_fg05c' on file 1.
Processed 22016 pages for database 'tp_v5_dev', file 'Interval_06' on file 1.
Processed 38704 pages for database 'tp_v5_dev', file 'Interval_fg06a' on file 1.
Processed 35408 pages for database 'tp_v5_dev', file 'Interval_fg06b' on file 1.
Processed 34840 pages for database 'tp_v5_dev', file 'Interval_fg06c' on file 1.
Processed 45920 pages for database 'tp_v5_dev', file 'Interval_fg07a' on file 1.
Processed 47080 pages for database 'tp_v5_dev', file 'Interval_fg07b' on file 1.
Processed 52416 pages for database 'tp_v5_dev', file 'Interval_fg07c' on file 1.
Processed 55120 pages for database 'tp_v5_dev', file 'Interval_fg08a' on file 1.
Processed 60064 pages for database 'tp_v5_dev', file 'Interval_fg08b' on file 1.
Processed 61808 pages for database 'tp_v5_dev', file 'Interval_fg08c' on file 1.
Processed 32392 pages for database 'tp_v5_dev', file 'Interval_09' on file 1.
Processed 64872 pages for database 'tp_v5_dev', file 'Interval_fg09a' on file 1.
Processed 63080 pages for database 'tp_v5_dev', file 'Interval_fg09b' on file 1.
Processed 60840 pages for database 'tp_v5_dev', file 'Interval_fg09c' on file 1.
Processed 13992 pages for database 'tp_v5_dev', file 'Interval_10' on file 1.
Processed 16272 pages for database 'tp_v5_dev', file 'Interval_fg10a' on file 1.
Processed 13352 pages for database 'tp_v5_dev', file 'Interval_fg10b' on file 1.
Processed 27160 pages for database 'tp_v5_dev', file 'Interval_fg10c' on file 1.
Processed 14720 pages for database 'tp_v5_dev', file 'Interval_11' on file 1.
Processed 16680 pages for database 'tp_v5_dev', file 'Interval_fg11a' on file 1.
Processed 28184 pages for database 'tp_v5_dev', file 'Interval_fg11b' on file 1.
Processed 13784 pages for database 'tp_v5_dev', file 'Interval_fg11c' on file 1.
Processed 15744 pages for database 'tp_v5_dev', file 'Interval_12' on file 1.
Processed 15040 pages for database 'tp_v5_dev', file 'Interval_fg12a' on file 1.
Processed 13936 pages for database 'tp_v5_dev', file 'Interval_fg12b' on file 1.
Processed 29944 pages for database 'tp_v5_dev', file 'Interval_fg12c' on file 1.
Processed 13200 pages for database 'tp_v5_dev', file 'Interval_13' on file 1.
Processed 23584 pages for database 'tp_v5_dev', file 'Interval_fg13a' on file 1.
Processed 12904 pages for database 'tp_v5_dev', file 'Interval_fg13b' on file 1.
Processed 26776 pages for database 'tp_v5_dev', file 'Interval_fg13c' on file 1.
Processed 15296 pages for database 'tp_v5_dev', file 'Interval_14' on file 1.
Processed 17840 pages for database 'tp_v5_dev', file 'Interval_fg14a' on file 1.
Processed 12320 pages for database 'tp_v5_dev', file 'Interval_fg14b' on file 1.
Processed 28320 pages for database 'tp_v5_dev', file 'Interval_fg14c' on file 1.
Processed 18400 pages for database 'tp_v5_dev', file 'Interval_fg15a' on file 1.
Processed 28928 pages for database 'tp_v5_dev', file 'Interval_fg15b' on file 1.
Processed 30744 pages for database 'tp_v5_dev', file 'Interval_fg15c' on file 1.
Processed 30088 pages for database 'tp_v5_dev', file 'Interval_fg16a' on file 1.
Processed 16184 pages for database 'tp_v5_dev', file 'Interval_fg16b' on file 1.
Processed 36504 pages for database 'tp_v5_dev', file 'Interval_fg16c' on file 1.
Processed 18968 pages for database 'tp_v5_dev', file 'Interval_17' on file 1.
Processed 14592 pages for database 'tp_v5_dev', file 'Interval_fg17a' on file 1.
Processed 30032 pages for database 'tp_v5_dev', file 'Interval_fg17b' on file 1.
Processed 31888 pages for database 'tp_v5_dev', file 'Interval_fg17c' on file 1.
Processed 22392 pages for database 'tp_v5_dev', file 'Interval_fg18a' on file 1.
Processed 30136 pages for database 'tp_v5_dev', file 'Interval_fg18b' on file 1.
Processed 37224 pages for database 'tp_v5_dev', file 'Interval_fg18c' on file 1.
Processed 33616 pages for database 'tp_v5_dev', file 'Interval_fg19a' on file 1.
Processed 30024 pages for database 'tp_v5_dev', file 'Interval_fg19b' on file 1.
Processed 29864 pages for database 'tp_v5_dev', file 'Interval_fg19c' on file 1.
Processed 36248 pages for database 'tp_v5_dev', file 'Interval_20a' on file 1.
Processed 27616 pages for database 'tp_v5_dev', file 'Interval_20b' on file 1.
Processed 27376 pages for database 'tp_v5_dev', file 'Interval_20c' on file 1.
Processed 12632 pages for database 'tp_v5_dev', file 'Interval_21' on file 1.
Processed 13080 pages for database 'tp_v5_dev', file 'Interval_fg21a' on file 1.
Processed 24608 pages for database 'tp_v5_dev', file 'Interval_fg21b' on file 1.
Processed 24288 pages for database 'tp_v5_dev', file 'Interval_fg21c' on file 1.
Processed 736 pages for database 'tp_v5_dev', file 'Interval_22b' on file 1.
Processed 992 pages for database 'tp_v5_dev', file 'Interval_fg22a' on file 1.
Processed 1032 pages for database 'tp_v5_dev', file 'Interval_fg22b' on file 1.
Processed 1088 pages for database 'tp_v5_dev', file 'Interval_fg22c' on file 1.
Processed 40 pages for database 'tp_v5_dev', file 'MatchType_Fg01_File01' on file 1.
Processed 40 pages for database 'tp_v5_dev', file 'MatchType_Fg02_File01' on file 1.
Processed 40 pages for database 'tp_v5_dev', file 'MatchType_Fg03_File01' on file 1.
Processed 40 pages for database 'tp_v5_dev', file 'MatchType_Fg04_File01' on file 1.
Processed 40 pages for database 'tp_v5_dev', file 'MatchType_Fg05_File01' on file 1.
Processed 40 pages for database 'tp_v5_dev', file 'MatchType_Fg06_File01' on file 1.
Processed 40 pages for database 'tp_v5_dev', file 'MatchType_Fg07_File01' on file 1.
Processed 40 pages for database 'tp_v5_dev', file 'MatchType_Fg08_File01' on file 1.
Processed 40 pages for database 'tp_v5_dev', file 'MatchType_Fg09_File01' on file 1.
Processed 40 pages for database 'tp_v5_dev', file 'MatchType_Fg10_File01' on file 1.
Processed 768 pages for database 'tp_v5_dev', file 'Interval_fg23a' on file 1.
Processed 784 pages for database 'tp_v5_dev', file 'Interval_fg23b' on file 1.
Processed 784 pages for database 'tp_v5_dev', file 'Interval_fg23c' on file 1.
Processed 838952 pages for database 'tp_v5_dev', file 'Interval_fg24a' on file 1.
Processed 732784 pages for database 'tp_v5_dev', file 'Interval_fg24b' on file 1.
Processed 804256 pages for database 'tp_v5_dev', file 'Interval_fg24c' on file 1.
Processed 520 pages for database 'tp_v5_dev', file 'Interval_fg25a' on file 1.
Processed 520 pages for database 'tp_v5_dev', file 'Interval_fg25b' on file 1.
Processed 520 pages for database 'tp_v5_dev', file 'Interval_fg25c' on file 1.
Processed 219528 pages for database 'tp_v5_dev', file 'Load40_01' on file 1.
Processed 156968 pages for database 'tp_v5_dev', file 'Load41_01' on file 1.
Processed 169880 pages for database 'tp_v5_dev', file 'Load42_01' on file 1.
Processed 860640 pages for database 'tp_v5_dev', file 'Load43_01' on file 1.
Processed 16 pages for database 'tp_v5_dev', file 'Load44_01' on file 1.
Processed 16 pages for database 'tp_v5_dev', file 'Load45_01' on file 1.
Processed 16 pages for database 'tp_v5_dev', file 'Load46_01' on file 1.
Processed 16 pages for database 'tp_v5_dev', file 'Load47_01' on file 1.
Processed 16 pages for database 'tp_v5_dev', file 'Load48_01' on file 1.
100 percent processed.
Processed 0 pages for database 'tp_v5_dev', file 'TradingOptimizer_v2_log' on file 1.
Processed 2 pages for database 'tp_v5_dev', file 'TradingOptimizerLog2' on file 1.
Processed 0 pages for database 'tp_v5_dev', file 'TradingOptimizerLog3' on file 1.
BACKUP DATABASE successfully processed 23884890 pages in 35.689 seconds (5228.521 MB/sec).

Now at 5.11 GB/s SQL backup to Null/3.12 GB/s local backup with I/O Accelerators

Additional resources