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@VM.MARIST.EDU] On Behalf Of Tom Alverson Sent: Monday, March 27, 2017 1:11 PM To: ADSM-L@VM.MARIST.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 <hoob...@us.ibm.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@VM.MARIST.EDU> wrote on 03/25/2017 > 12:20:43 AM: > > > From: Tom Alverson <tom.alver...@gmail.com> > > To: ADSM-L@VM.MARIST.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@VM.MARIST.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 <hoob...@us.ibm.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@VM.MARIST.EDU> wrote on > > > 03/15/2017 > > > 02:39:04 PM: > > > > > > > From: "Alford, Ben" <balf...@utk.edu> > > > > To: ADSM-L@VM.MARIST.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@VM.MARIST.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 > > > > > > > > > >