ADSM-L

[ADSM-L] AW: SQL TDP lan free backup on VMWARE

2009-01-28 03:06:34
Subject: [ADSM-L] AW: SQL TDP lan free backup on VMWARE
From: Stefan Holzwarth <stefan.holzwarth AT ADAC DOT DE>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 28 Jan 2009 09:05:23 +0100
We backup 3 different Exchange Servers (DL380 G5) one after one - all with 
identical results over 1 GB ethernet nic - see example:
TSM Server is also windows x86 using only disks.

01/18/2009 18:05:06 
=========================================================================
01/18/2009 18:05:06 Request                       : Backup
01/18/2009 18:05:06 SG List                       : *  
01/18/2009 18:05:06 Backup Type                   : FULL  
01/18/2009 18:05:06 Database Name                 :   
01/18/2009 18:05:06 Buffers                       : 3  
01/18/2009 18:05:06 Buffersize                    : 1024  
01/18/2009 18:05:06 Exchange Server               : VEX01003  
01/18/2009 18:05:06 TSM Node Name                 :   
01/18/2009 18:05:06 TSM Options File              : 
c:\adsm32\TDPExchange\dsm_VEX01003EXCH.opt  
01/18/2009 18:05:06 Mount Wait                    : Yes  
01/18/2009 18:05:06 Quiet                         : No  
01/18/2009 18:05:06 
-------------------------------------------------------------------------
01/18/2009 19:19:37 Total storage groups requested for backup:  2
01/18/2009 19:19:37 Total storage groups backed up:             2
01/18/2009 19:19:37 Total storage groups expired:               52
01/18/2009 19:19:37 Total storage groups excluded:              0
01/18/2009 19:19:37 Throughput rate:                            52,493.79 Kb/Sec
01/18/2009 19:19:37 Total bytes transferred:                    240,195,943,048
01/18/2009 19:19:37 Elapsed processing time:                    4,468.46 Secs
01/18/2009 19:19:37 --- SCHEDULEREC OBJECT END EXCHBACKUP 01/18/2009 19:19:37


Optfile used:
NODename          VEX01003EXCH
CLUSTERnode       YES
COMMMethod        TCPip
TCPPort           1502
TCPServeraddress  SDE14001-GB4
TCPWindowsize     256
TCPBuffSize       512
COMPRESSION               OFF
RESOURCEUTILIZATION       3
...

Regards,
Stefan Holzwarth

> -----Ursprüngliche Nachricht-----
> Von: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] Im 
> Auftrag von Schaub, Steve
> Gesendet: Dienstag, 27. Januar 2009 18:02
> An: ADSM-L AT VM.MARIST DOT EDU
> Betreff: Re: SQL TDP lan free backup on VMWARE
> 
> Howard,
> 
> Can you share the Exchange server physical config 
> (cpu/mem/disk) as well
> as the .cfg you use for these Exchange servers?  Are they x86 
> Ex2003 or
> x64?  Did it run this well out of the box or did you need to 
> tweak it to
> reach this point?  We have several Ex2003 servers, one of which has a
> total of 909gb in 4 SG's and is taking 16.5hrs to do a full 
> backup (.857
> gb/min).  it is gig attached, and the tsm server is using a multi-gig
> trunked line.  I just cant seem to squeeze any more speed out of this
> backup and I would love to find out how you are doing it.
> 
> Thanks,
> 
> Steve Schaub
> Systems Engineer, Windows
> BlueCross BlueShield of Tennessee
> steve_schaub AT bcbst DOT com
> 
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] 
> On Behalf Of
> Howard Coles
> Sent: Monday, January 26, 2009 5:13 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: [ADSM-L] SQL TDP lan free backup on VMWARE
> 
> We have 4 Storage Groups per Node, and 3 nodes.  However, 1 node is
> about 600 GB, the other two add up to about 600 GB.  They all 
> backup at
> the same time of the night, when they do a full backup on 
> each box.  We
> have other Exchange nodes that backup at various times but these three
> (being the largest) I have backing up at a time when they can 
> have more
> bandwidth.  We back them up via the LAN (1 GB NICS each) directly to
> disk.  They all take about 4 (sometimes 5) hours each to backup unless
> the LAN is congested which means the total backup time for 
> the 1.2 TB is
> around 4 to 4.5 hours, which is about 4.5 - 5 GB per Min.  Which means
> we're pushing the TSM Server's NIC to about the edge. :-D
> 
> The TSM server has 1, 1GB NIC (Teamed in Failover mode).  Note: The 1
> Largest node only takes 4 hours to do a full backup.  We used to have
> them in a direct to SAN backup, but discovered that doesn't work much
> faster than doing the LAN backup, and has the added burden of 
> tying up 1
> or more Tape drives per node, which could be doing other things.  Now,
> if I had a 1.2 TB single system, this would be a no brainer for Direct
> over SAN backup. But until it gets bigger than 8-9 hundred GB 
> it really
> does work out to be equal either way.  
> 
> See Ya'
> Howard
> 
> 
> > -----Original Message-----
> > From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] 
> On Behalf
> > Of Len Boyle
> > Sent: Monday, January 26, 2009 3:11 PM
> > To: ADSM-L AT VM.MARIST DOT EDU
> > Subject: Re: [ADSM-L] SQL TDP lan free backup on VMWARE
> > 
> > Howard,
> > 
> > Can you give the list a little more details on the Exchange system
> > backup of 1.2 TB in about 4 or so hours.
> > 
> > How many exchange storage groups do you have and how many of them
> > backup up in parallel?
> > How large are they?
> > Are you using multiple nics of 1gig each or a 10gig nic?
> > 
> > Thanks len
> > 
> > -----Original Message-----
> > From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] 
> On Behalf
> > Of Howard Coles
> > Sent: Monday, January 26, 2009 3:34 PM
> > To: ADSM-L AT VM.MARIST DOT EDU
> > Subject: Re: [ADSM-L] SQL TDP lan free backup on VMWARE
> > 
> > Not necessarily.  You would think so, but in my experience your at
> > about
> > the break even point.  Due to the SAN having to go to tape, 
> as opposed
> > to being able to go to disk on a LAN backup.  I backup a 
> few Exchange
> > systems via TDP that equal about 1.2 TB in about 4 or so hours.
> > 
> > However, a good strategy would be to do a full once a week or month
> and
> > do diffs or incremental each day for speed's sake.
> > 
> > See Ya'
> > Howard
> > 
> > 
> > > -----Original Message-----
> > > From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On
> Behalf
> > > Of Adrian C. Pardo
> > > Sent: Monday, January 26, 2009 2:26 PM
> > > To: ADSM-L AT VM.MARIST DOT EDU
> > > Subject: Re: [ADSM-L] SQL TDP lan free backup on VMWARE
> > >
> > > Mark,
> > > The customer required to use the TDP, so, the way will be TDP via
> > LAN,
> > > but
> > > 700 Gg in a Lan...will take longer than in a SAN..
> > >
> > > Adrian
> > >
> > >
> > >
> > > -----Mensaje original-----
> > > De: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] 
> En nombre
> > de
> > > Mark
> > > Stapleton
> > > Enviado el: Lunes, 26 de Enero de 2009 18:18
> > > Para: ADSM-L AT VM.MARIST DOT EDU
> > > Asunto: Re: [ADSM-L] SQL TDP lan free backup on VMWARE
> > >
> > > You'd be surprised on what little difference there can be between
> LAN
> > > and
> > > SAN backups. However...
> > >
> > > Your next best bet is to do a dump of the database to a flat file,
> > and
> > > then
> > > using the LAN-free storage agent to back that up across 
> the SAN (to
> > > tape
> > > only, I'm afraid). If you don't have the storage agent license
> > > purchased,
> > > you'll need to do that in order to do SAN-based backups 
> on that box.
> > >
> > > --
> > > Mark Stapleton
> > > System engineer, CDW
> > >
> > >
> > > -----Original Message-----
> > > From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On
> Behalf
> > > Of
> > > Adrian C. Pardo
> > > Sent: Monday, January 26, 2009 2:02 PM
> > > To: ADSM-L AT VM.MARIST DOT EDU
> > > Subject: Re: [ADSM-L] SQL TDP lan free backup on VMWARE
> > >
> > > Stef
> > >
> > > Well, next question, how can we do a Lan Free backup of these SQL
> > > bases...
> > > Doing via LAN will take forever!!
> > >
> > > Adrian
> > >
> > >
> > > -----Mensaje original-----
> > > De: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] 
> En nombre
> > de
> > > Stef
> > > Coene
> > > Enviado el: Lunes, 26 de Enero de 2009 17:50
> > > Para: ADSM-L AT VM.MARIST DOT EDU
> > > Asunto: Re: [ADSM-L] SQL TDP lan free backup on VMWARE
> > >
> > > On Monday 26 January 2009, Adrian C. Pardo wrote:
> > > > We need to backup a SQL database Using TDP and Lan Free on a
> > VMware
> > > > machine (the database size is 700Gig Aprox)
> > > >
> > > > Any sugestion??
> > > Not possible.  The client can not access the hardware for SAN
> access.
> > >
> > >
> > > Stef
> > >
> > > No virus found in this incoming message.
> > > Checked by AVG.
> > > Version: 7.5.552 / Virus Database: 270.10.13/1916 - Release Date:
> > > 1/26/2009
> > > 7:08 AM
> > >
> > >
> > > No virus found in this outgoing message.
> > > Checked by AVG.
> > > Version: 7.5.552 / Virus Database: 270.10.13/1916 - Release Date:
> > > 1/26/2009
> > > 7:08 AM
> 
> -----------------------------------------------------
> Please see the following link for the BlueCross BlueShield of 
> Tennessee E-mail disclaimer:  
> http://www.bcbst.com/email_disclaimer.shtm
>