1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This message will disappear after you have made at least 12 posts. Thank you for your cooperation.

SQL compression with TDP for SQL

Discussion in 'Microsoft SQL Server' started by Xeroid, Nov 7, 2012.

  1. Xeroid

    Xeroid New Member

    Joined:
    Jul 29, 2010
    Messages:
    18
    Likes Received:
    0
    Location:
    Belgium
    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
     
  2.  
  3. Trident

    Trident Senior Member

    Joined:
    Apr 2, 2007
    Messages:
    277
    Likes Received:
    25
    Occupation:
    IT operations
    Location:
    Oslo, Norway
    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.
     
  4. Trident

    Trident Senior Member

    Joined:
    Apr 2, 2007
    Messages:
    277
    Likes Received:
    25
    Occupation:
    IT operations
    Location:
    Oslo, Norway
    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
     
  5. Xeroid

    Xeroid New Member

    Joined:
    Jul 29, 2010
    Messages:
    18
    Likes Received:
    0
    Location:
    Belgium
    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?
     

Share This Page