I have a question about the target device, can an LTO-5 write at 20MB/sec? Perhaps an intermediate landing zone that can write that slow might help.
Andy Huebner -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of Håkon Phillip Tønder-Keul Sent: Friday, August 23, 2013 12:08 PM To: [email protected] Subject: Re: [ADSM-L] TDP SQL backup performance On 08/23/2013 04:07 PM, Sven Seefeld wrote: > Hi, > > we're experiencing slow performance while backing up a 1,5 TByte MS > SQL 2008R2 database with the TDP SQL Agent 6.3. As for DR-scenarios, > we're doing legacy backups only. The actual speed is usually around 20 > MByte/s, backups go to > LTO-5 tape directly. The backup stream has to pass through 3 different > firewalls, so we're not quite sure where the bottle neck is located, > MS SQL API, TDP Agent or IP-firewall (SAN-Storage and TSM-Server > should outperform everything else). > > Maybe someone can share his performance values with me. Any hints are welcome. > > > Regards, > > > Sven Hi, Can you pos tyour dsm.opt and tdpsql.cfg? There is a lot of tuning that can boost your perfomance. -- Mvh/Rgds Håkon Phillip Tønder-Keul Senior Consultant
