How can we help you today? How can we help you today?

Compression Analyzer - try out the compression levels

In the install directory of SQL Backup 5 Beta you will find a standalone application CompressionAnalyzer.exe which you can use to test the different compression levels SQL Backup offers on your databases.

You can stop the sampling part way through to give you an estimate of what compression you can expect to achieve without having to run a complete full backup using each compression level.

Note:
1. You will need to install the server components prior to running CompressionAnalyzer.exe (run SQBServerSetup.exe or install via the GUI)

Please post your comments about this feature here.
HJoyce
0

Comments

2 comments

Sort by
  • JulianKuiters
    It seems like a useful tool.

    Issues:

    1. The list of servers in Select Servers is not sorted.

    2. Cannot select a remote server that SQL Backup is not installed in (it would be great to see if a remote server using native backups would benefit from using SQL Backups compression. Think Justification/ROI Expendature Reports.)

    3. It would be good to know time differences for compression levels as well as size differences.

    4. Adding it to the main SQL Backup GUI would be nice.

    5. Exporting a report (for a whole server) would be great (again ROI / see point #2)

    6. Expected vs Actual/Historical would be great from within the main SQL Backup GUI.


    I'm expecting this will show different compression settings are more appropriate for different databases.
    JulianKuiters
    0
  • sangha
    It looks good.

    1.)
    But it would be more useful calling from step 4 of Backup wizard. A button placed next to Compress backup option in step 4 would help the user estimate what compression can be achieved in each level. The database/server details can be passed as command line parameters to the utility.


    2.)
    Also if possible an estimate of how much time it will take to backup for each compression level would be really useful.
    sangha
    0

Add comment

Please sign in to leave a comment.