If you're using TDP for SQL you can specify how many stripes to use in the
tdpo.cfg file.
For our large SQL backups, I use 10 stripes.
__________________________
Matthew McGeary
Senior Technical Specialist – Infrastructure Management Services
PotashCorp
T: (306) 933-8921
www.potashcorp.com
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Tom Alverson
Sent: Monday, March 27, 2017 1:11 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Best Practices/Best Performance SP/TSM B/A Client
Settings ?
Our biggest performance issue is with SQL backups of large databases. Our DBA's
all want full backups ever night (and log backups every hour) and for the
databases that are around 1TB the backup will start at Midnight and finish 5 to
13 hours later (varies day to day). When these backups start extending into
the daytime hours they complain but I don't know how we could improve the
speed. Our Storage servers all have 10GB interfaces but they are backing up
hundreds of clients every night (mostly incremental file level backups). I am
running a test right now to see if RESOURCEUTILIZATION 10 helps one of these
database backups but I suspect it will make no difference as 99% of the data is
all in one DB and I don't think SQL/TSM will split that into multiple streams
(will it?).
On Sun, Mar 26, 2017 at 6:57 AM, Del Hoobler <hoobler AT us.ibm DOT com> wrote:
> Hi Tom,
>
> My original posting was an excerpt from best practices for container
> pools, and does not necessarily apply to other storage pool types.
>
> Yes, client-side deduplication and compression options should be
> avoided with a Data Domain storage pool.
>
> A fixed resourceutilization setting of 2 may underperform for clients
> that have a lot of data to back up and fast network connections, but
> this is not a black and white answer. There are various other
> conditions that can affect this and trying to narrow in on them in ADSM-L
> would be difficult.
> If you want some help with a performance issue, please open a PMR.
>
>
> Del
>
> ----------------------------------------------------
>
> "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 03/25/2017
> 12:20:43 AM:
>
> > From: Tom Alverson <tom.alverson AT GMAIL DOT COM>
> > To: ADSM-L AT VM.MARIST DOT EDU
> > Date: 03/25/2017 05:40 AM
> > Subject: Re: Best Practices/Best Performance SP/TSM B/A Client
> > Settings
> ?
> > Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> >
> > Del:
> >
> > We have been using these settings as our defaults. Is our
> > TCPWINDOWSIZE too large?
> >
> > RESOURCEUTILIZATION 2 (we increase this up to 10 for some WAN
> > backups) TXNBYTELIMIT 2097152 TCPNODELAY YES TCPBUFFSIZE 512
> > TCPWINDOWSIZE 2048 LARGECOMMBUFFERS YES
> >
> > Also we never use compression because our storage folks believe it
> > will foul up the de-duplication that happens on our Data Domains??
> >
> > On Mon, Mar 20, 2017 at 9:11 PM, Del Hoobler <hoobler AT us.ibm DOT com>
> > wrote:
> >
> > > Hi Ben,
> > >
> > > Here are some items to get you started:
> > >
> > >
> > > Backup-Archive client with limited, high latency network (WAN
> backups):
> > > ===============================
> > > TCPWINDOWSIZE 512
> > > RESOURCEUTILIZATION 4
> > > COMPRESSION Yes
> > > DEDUPLICATION Yes
> > > ENABLEDEDUPCACHE Yes
> > >
> > > Tip: Do not use the client deduplication caching for applications
> that
> > > use the IBM Spectrum Protect API. Refer to section 1.2.3.2.1 for
> > > additional details.
> > >
> > >
> > > Backup/Archive client or Client API with limited network (Gigabit
> > > LAN
> > > backups):
> > > ===============================
> > > TCPWINDOWSIZE 512
> > > RESOURCEUTILIZATION 10
> > > COMPRESSION Yes
> > > DEDUPLICATION Yes
> > > ENABLEDEDUPCACHE No
> > >
> > >
> > > Backup/Archive client or Client API with high speed network (10
> Gigabit +
> > > LAN backups)
> > > ===============================
> > > TCPWINDOWSIZE 512
> > > RESOURCEUTILIZATION 10
> > > COMPRESSION No
> > > DEDUPLICATION No
> > > ENABLEDEDUPCACHE No
> > >
> > >
> > > Tip: For optimal data reduction, avoid the following client
> > > option
> > > combination:
> > >
> > > COMPRESSION Yes
> > > DEDUPLICATION No
> > >
> > >
> > >
> > >
> > > Del
> > >
> > > ----------------------------------------------------
> > >
> > > "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on
> > > 03/15/2017
> > > 02:39:04 PM:
> > >
> > > > From: "Alford, Ben" <balford AT UTK DOT EDU>
> > > > To: ADSM-L AT VM.MARIST DOT EDU
> > > > Date: 03/15/2017 02:39 PM
> > > > Subject: Best Practices/Best Performance SP/TSM B/A Client
> > > > Settings
> ?
> > > > Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> > > >
> > > > I've looked at the IBM Blueprint documents but may have missed
> > > > what I was looking for - the Best Practices for Best Performance for TSM
> > > > B/A client settings. As we move from 6.4 to 7.x or 8.x clients
> > > > before the 6.4 EOL, we are looking to test with the current
> > > > client settings optimized for things like TCPBUFFSIZE,
> > > > TCPWINDOWSIZE, TXNBYTLIMIT, etc., etc.
> > > > Thanks!
> > > >
> > > > Ben Alford
> > > > IT Manager, Office of Information Technology
> > > > Systems: Shared Services
> > > >
> > > > The University of Tennessee
> > > >
> > >
> >
>
|