on 04-14-2014 5:04 AM
Hi,
One of our client is taking the SAP SQL database backup using BRTOOL, backup happen on Standalone LTO 5.
They are taking backup of 1.4 TB in 1hr 30 Min.
I would like to know is it possible to achieve same as max write speed of LTO 5 in 140 MBPS, if we consider the are getting max throughput rate then too it should take around 3 hr 40 Min.
If it is possible then it would be grateful if someone can explain how.
Thanks & Regards
Mitt Gori
Hi Mitt,
As your database is MSSQL not sure how you guys are using brtools ? It is meant for oracle database only.
You may use MSSQL Enterprise manager to schedule the backup or use db13.
Note: Requesting Moderator to shift this thread to MSSQL database.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mitt,
It depends on I/O speed, LTO write speed , also how many parallel writes are being made to tapes.
If you say only single tape is being used for backup 1.4 TB of data, I am doubtful that it may get completed in 1hr 30 mins using traditional backup methods of SAP.
If you go with snapshot backup solutions then probably such timings can be made possible.
Hope this helps.
Regards,
Deepak Kori
Hi Mitt,
You may refer the details shared under thread Full Database Backup in DB13 for MS SQL Server ... | SCN on configuration of backups using db13 for MSSQL.
What it comes to my mind is ..
1) Can you check whether you have SSDs configured for the database
2) What is the Tape write speed.
Note: SSD disks can drastically improve the backup times as it has excellent read/write performance over SAS disk.
Hope this helps.
Regards,
Deepak Kori
I can't claim lots of familiarity with LTO 5 tape systems, but if it's max transfer speed is 150 MBps, then simple math says that if this is the slowest point in the transfer, the bottleneck, then in a perfect world a 1.4 TB backup would take at least 2.7 hours. And, of course, we don't live in a perfect world, transfers are never consistently at the full speed, are they? So, if they truly are getting something that is approximately half that time for a full backup, they must be writing to tape devices in parallel.
Regards,
Matt
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.