SQL Backtrack: Lousy performance on restores over TCP/IP

Hi all,

We've been testing with ADSM and SQL*Backtrack to backup an oracle database
and we noticed a *very* slow restore time restoring a full phisical backup. 

The configuration is: RS/6000 SP, thin node with ADSM Server 2.1.5.13, other
hin node with ADSM Client 2.1.0.6, SQL Backtrack 2.2.1 and Oracle 7.3.2. OS
is AIX 4.1.5. Backups are going through the SP switch directly to a 3590.

When we backup, we get about 4MB/sec throughput, but only 800KB/sec on
restores. We notice there is a large amount of idle CPU during restores.

We tried with client and server on the same node using shared memory and we
get close to 3MB/sec on restores, but using tcpip we still get the same
800KB/sec. So it seems to be tcp related, but we have no clue as why it's
only affecting the restores.

Anyone experienced this before?

--
Rui Malheiro,
Rui Malheiro,
6 Mil - Tecnologias de Informacao
URL: <http://www.6mil.pt/>

<Prev in Thread]	Current Thread	[Next in Thread>
SQL Backtrack: Lousy performance on restores over TCP/IP, Rui Malheiro <= Re: SQL Backtrack: Lousy performance on restores over TCP/IP, Harold Rubin Re: SQL Backtrack: Lousy performance on restores over TCP/IP, Rui Malheiro

Previous by Date:	Re: NT Service and Logical Drives, Moir,Elizabeth
Next by Date:	Re: PASSWORDACCESS GENERATE - problem, Zvi Bar-Deroma
Previous by Thread:	ADSM & ATM, Harold Rubin
Next by Thread:	Re: SQL Backtrack: Lousy performance on restores over TCP/IP, Harold Rubin
Indexes:	[Date] [Thread] [Top] [All Lists]