SQL compression with TDP for SQL

[Xeroid]

Hi guys,

I have upgraded the tdp for sql to 6.3.0 and I have a support version of SQL server running.
I enabled SQL compression both as option in the backup agent and in Management studio. After I take a (always legacy) backup I can see in the restore db window 'sql compression' -> yes.
However if I query the session on TSM server (6.3.0) I see that it is sending over all of the Mbytes, so no indication there about sql compression there. Neither in the dsmsched files. I would be expecting a huge saving, but seems like this option is doing nothing for me?

Thanks for your reply!

Dennis

 

[Trident]

A indication is to look at the CLI when running tdpsqlc backup * full. The figure you see there is Mbytes/sec transferred out from SQL. Then look at TaskManager (network). The speed you see there is after TSM has compressed your data. I typically get 200Mbytes/sec from the sql server, and used 100Mbytes/sec in transfer speed.

 

[Trident]

SQL 6.3.0.1 gives you this:

Total SQL backups selected: 3
Total SQL backups attempted: 3
Total SQL backups completed: 3
Total SQL backups excluded: 0
Total SQL backups inactivated: 0
Total SQL backups deduplicated: 0

Throughput rate: 1,487.35 Kb/Sec
Total bytes inspected: 21,340,928
Total bytes transferred: 5,184,456
Total LanFree bytes transferred: 0
Total bytes before deduplication: 0
Total bytes after deduplication: 0
Data compressed by: 76%
Deduplication reduction: 0,00%
Total data reduction ratio: 75,71%
Elapsed processing time: 3.40 Secs

 

[Xeroid]

Aren't you looking at the TDP compression then instead of the sql compression?

have you set 'sqlcompression yes' in tdpsql.cfg? Or 'compression yes' in dsm.opt?