On Tue, Mar 6, 2012 at 2:08 PM, Richard McClary <[email protected]> wrote: > Any ideas as to what might be slowing down the copy process?
Insufficient data for a meaningful answer. Start with the nodes involved: AA = database server BB = backup processor CC = old backup storage target DD = new backup storage target For each node, describe: * Make and model of machine * Physical CPU * Physical RAM * HDD (spindle speed, spindle count, disk/controller cache, attachment type & speed) * OS, Edition, 32/64 bit, Service Pack If the node is virtualized, also provide: * Virtualization software and version * Host OS, Edition, 32/64 bit, Service Pack (if not dedicated virtualization OS) * CPU assigned * RAM assigned * Type of virtual storage (virtual disk, pass-through, etc.) You provided some of this information for CC and DD only. > ... our DB2 databases where a VM (running > DB2 for the tools) would back up our medical records database (on another > server), create ZIP files (the zip script was set to create zip files from > the database backup in 4 Gb chunks), then copy those chunks to a user’s > desktop PC. So... to divide this into stages: P1. Software running on BB connects via network to AA, running DB2 protocols over the wire, and dumps database data to files on local storage P2. Software running on BB compresses those files to ZIPs, also on local storage P3. Software running on BB connects via network to CC or DD, using SMB, and copies the ZIP files from local storage to storage on the remote node Is this correct? Does the DBA know if steps P1 and P2 are still taking the same amount of time? If not, the problem might be in P2 or P2 and just happened to start around the same time as the CC to DD switch was made. Sure, this is an unlikely coincidence, but they do happen. Also, is the network path from BB to CC, and from BB to DD, identical -- down to the switch port, wall jack, and cables? -- Ben ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin
