ADSM-L

TDP FOR SQL DATABASES 5.2

2005-12-01 12:04:42
Subject: TDP FOR SQL DATABASES 5.2
From: Laura Mastandrea <lmastand AT CHOOSEBROADSPIRE DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 1 Dec 2005 11:04:31 -0600
We have been evaluating this product and have not been able to achieve the
necessary performance throughput on the restores we require.  I'd like to
know if anyone else out there is successfully using this product.

Environment:

AIX 5.2  and TSM Server 5.2.4.2
6 STK 9840 B tape drives, but we always backup directly to a 1 TB disk pool
Windows 2003  TSM client 5.3.0.8
SQL Server 2000 SP3
Test database 50 GB

Backup times are 42 minutes and restore times are 73 minutes with 6
stripes.   Our production databases will be 3 to 4 times bigger than this
test database.  The TSM buffer is 4096.  The node is non-collocated, but we
have tried with collocated.  The best we could do was get the migration
from disk to "stripe" across 3 volumes.  IBM's recommendation is to go LAN
free, but that is not an option at this point.

Thank you.








DISCLAIMER:
This communication, along with any documents, files or attachments, is intended 
only for the use of the addressee and may contain legally privileged and 
confidential information. If you are not the intended recipient, you are hereby 
notified that any dissemination, distribution or copying of any information 
contained in or attached to this communication is strictly prohibited. If you 
have received this message in error, please notify the sender immediately and 
destroy the original communication and its attachments without reading, 
printing or saving in any manner. This communication does not form any 
contractual obligation on behalf of the sender or, the sender's employer, or 
the employer's parent company, affiliates or subsidiaries.


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