Results 1 to 4 of 4
  1. #1
    Newcomer
    Join Date
    Jul 2010
    Location
    Belgium
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question SQL compression with TDP for SQL

    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. #2
    Senior Member Trident's Avatar
    Join Date
    Apr 2007
    Location
    Oslo, Norway
    Posts
    269
    Thanks
    2
    Thanked 19 Times in 19 Posts

    Default

    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 =-

  3. #3
    Senior Member Trident's Avatar
    Join Date
    Apr 2007
    Location
    Oslo, Norway
    Posts
    269
    Thanks
    2
    Thanked 19 Times in 19 Posts

    Default

    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
    -= Trident =-

  4. #4
    Newcomer
    Join Date
    Jul 2010
    Location
    Belgium
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    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?

Similar Threads

  1. Replies: 1
    Last Post: 05-31-2011, 11:47 AM
  2. TDP and SQL 2008 Backup Compression
    By Schmalenbach in forum Microsoft SQL Server
    Replies: 3
    Last Post: 11-10-2009, 09:28 AM
  3. Replies: 2
    Last Post: 07-24-2009, 02:09 PM
  4. TDP SQL on cluster unable to backup SQL Database
    By sailesh in forum Backup / Archive Discussion
    Replies: 8
    Last Post: 07-12-2007, 05:43 AM
  5. Restoring a SQL database with TSM SQL server TDP v5.1.5.0
    By gavinring in forum TDP/Application Layer Backup
    Replies: 1
    Last Post: 07-15-2004, 04:36 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •