ADSM-L

Re: TDP for SQL Restore Performance

2000-05-17 11:07:04
Subject: Re: TDP for SQL Restore Performance
From: Richard Smith <richard.smith.hs45 AT STATEFARM DOT COM>
Date: Wed, 17 May 2000 10:07:04 -0500
Matthew,

Sorry for the lack of detail here's some more info that should help:

Backup:

I'm backing a database approximately 1GB (uncompressed) in size and the
backup takes about 2 mins. The backup goes straight to tape. A backup to
disk takes about 3 mins.

Restore:

The restore of that same database took about 20 mins.

Client:
HP LXR PRO 8, 2x200 MHz processors, 1GB RAM, Client version 1.1.2.01

Server:
IBM Network Storage Manager, 2x332 MHz processors (H50), 512 MB RAM, Server
version 3.7.1, 3494 tape library with 3590 tape drives.

Network:
100 Mb Ethernet dedicated (no other traffic) set to full duplex.

Thanks again,

Rick Smith
Storage Management LTSB Team
State Farm Insurance
(309) 735-3086


<Prev in Thread] Current Thread [Next in Thread>