Welcome to MSSQL Compressed Backup!

Please read through the documentation if you just want to get started the examples on the getting started examples page should be enough to get rolling!

Getting Started

Command Line Reference

Pipeline Reference

Standard Plugin Reference

These tests were run on an 8 Gigabyte copy of the DVD 2 Store database. The database was located on a Ram disk and all writes were to a SAS attached SSD. 8 files were used and a MAXTRANSFERSIZE of one megabyte was chosen. The test machine was a Core i7 2600K with 32GB of ram using SQL Server 2012 Developer Edition.

Compressor is the compression method and level if that is available. Time is in seconds. Backup size is in bytes. The differences are expressed in percentages.

None 20.827 344.766 7530537984 0.00 0.00 0.00
gzip level 1 149.480 48.036 2604037747 -617.72 -617.72 65.42
gzip level 2 155.266 46.246 2559681554 -645.50 -645.50 66.01
gzip level 3 176.179 40.756 2524592084 -745.92 -745.93 66.48
gzip level 4 161.966 44.333 2556010759 -677.67 -677.67 66.06
gzip level 5 236.637 30.343 2319155998 -1036.20 -1036.23 69.20
gzip level 6 308.708 23.259 2303989983 -1382.25 -1382.29 69.40
gzip level 7 370.882 19.360 2301086759 -1680.77 -1680.82 69.44
gzip level 8 792.696 9.058 2299377463 -3706.10 -3706.20 69.47
gzip level 9 1072.720 6.693 2298583722 -5050.62 -5051.14 69.48
zip64 level 1 148.383 48.391 2604015899 -612.45 -612.46 65.42
zip64 level 2 157.447 45.605 2559732351 -655.98 -655.98 66.01
zip64 level 3 175.308 40.959 2524591118 -741.73 -741.73 66.48
zip64 level 4 161.523 44.454 2556021935 -675.55 -675.56 66.06
zip64 level 5 237.182 30.273 2319119360 -1038.82 -1038.86 69.20
zip64 level 6 307.123 23.379 2303897846 -1374.64 -1374.68 69.41
zip64 level 7 369.727 19.420 2301101953 -1675.23 -1675.31 69.44
zip64 level 8 789.206 9.098 2299286893 -3689.34 -3689.47 69.47
zip64 level 9 1071.505 6.701 2298572681 -5044.79 -5044.99 69.48
bzip2 level 1 1050.830 6.833 1969014674 -4945.52 -4945.60 73.85
bzip2 level 2 1021.742 7.027 1847529888 -4805.85 -4806.30 75.47
bzip2 level 3 1020.599 7.035 1791238150 -4800.36 -4800.72 76.21
bzip2 level 4 1028.623 6.980 1759601593 -4838.89 -4839.34 76.63
bzip2 level 5 1037.066 6.923 1738787290 -4879.43 -4880.01 76.91
bzip2 level 6 1046.385 6.862 1724337750 -4924.18 -4924.28 77.10
bzip2 level 7 1053.827 6.813 1712456828 -4959.91 -4960.41 77.26
bzip2 level 8 1062.261 6.759 1702714843 -5000.40 -5000.84 77.39
bzip2 level 9 1074.006 6.685 1694468647 -5056.80 -5057.31 77.50
LZ4 6.111 1175.003 3531358036 70.66 70.66 53.11

Last edited Nov 7, 2013 at 3:28 AM by SQLServerIO, version 13