Re: Very slow DB RESTORE performance

2014-10-08 Thread Skylar Thompson
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 performa

Very slow DB RESTORE performance

2014-10-08 Thread Matthew McGeary
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 driv