Could it be disk drive contention? It sounds like you're filling up your buffer cache, and then waiting for it to be flushed to disk.
On Wed, Oct 08, 2014 at 03:03:12PM -0600, Matthew McGeary wrote: > Folks, > > I'm restoring my TSM DB to a new host and have run into some extremely > slow performance restoring the DB. It seems to process a few hundred MB > and then pause for 5-10 seconds before starting up again. The new host is > a Power8 S22 with 20 cores and 256GB of RAM, running AIX. The tape drives > have two 4Gb HBAs connected and the disk has four 8Gb. I'm looking at a > 2.3 TB database that will take approx 13 hours to restore. > > Any ideas on why it's slow and how it could be sped up would be > appreciated. -- -- Skylar Thompson ([email protected]) -- Genome Sciences Department, System Administrator -- Foege Building S046, (206)-685-7354 -- University of Washington School of Medicine
