Thank you so much! We’ve done that for large file server backups as well with great results. Will try that out.
Hi BackupGuy,
Thanks for your question, I can see Damian has provided an answer, but I just wanted to throw 2 cents in as well. Damian, feel free to correct anything I am wrong on below.
SQL Server streaming backup, by default, will use 2 streams, this is configurable from the subclient options and given the size of your DB, if network or storage is not the bottleneck here, then increasing streams could increase concurrency of the data transfer from SQL Server and result in faster backups. If you have enabled VSS for the instance it will definitely be a single streamed backup. Do you have VSS enabled for the instance?
Can you give me more context on this? Why might you not get support?
“I’ve been told Intellisnap is the way but I might not get support to go down that road.”
If I had to make a choice between IntelliSnap and Block-Level for a 7 TB database, I would choose IntelliSnap all the way. If only for the backup performance. Whilst Block-Level backup does perform a VSS Shadow operation, it still needs to stream data out. IntelliSnap on the other hand will take a hardware level snap which is much faster. Then at a later date you can perform a backup copy to move the data from the snapshot onto your library storage. This operation can be performed completely on the MediaAgents at any time you like, so you can schedule for times when the system is less utilised and it won’t impact the client.
Hope this helps.
David
Hello Guys,
I have the same problem. I’m trying to restore SQL database about 5 TB. We have 10G/sec network on media agnet and on client. WE have tried enable/disable jumbo frame on switch and on servers. There is no firewall between client and MA. But we are unable to see good troughput. I see max 1.7 tb/h truughput.
SQL server is located on VMware ssd disks.
Windows Server 2012 64bit.
Is there anything to check or any suggestion ?
Thank you
Hi ETO,
Without seeing the logs, it’s hard to determine where the bottleneck is. The key places to be checking are media read speed, network performance and storage write speed on the destination.
Are you using IntelliSnap, Block-Level or streaming here? If it’s snap, is it coming from the snap copy or from primary?
Assuming it’s streaming, you can see media read speed in the CVD.log on the MediaAgent, and the SQLiDA.log on the destination client will give you the SQL performance (SQL Writer Timer).
If you wanted to test the current network performance between the MA and the client, Commvault packages the CVNetworkTestTool.
You will need to run one side of the utility in Server Mode:
https://documentation.commvault.com/commvault/v11/article?p=7584.htm
The other in Client Mode:
https://documentation.commvault.com/commvault/v11/article?p=7590.htm
And it will send data between the two utilities and let you know the throughput
Also make sure that CV and MSFT AV exclusions are in place where necessary:
CV: https://documentation.commvault.com/11.24/expert/8665_recommended_antivirus_exclusions_for_windows.html
MSFT: https://support.microsoft.com/en-us/topic/how-to-choose-antivirus-software-to-run-on-computers-that-are-running-sql-server-feda079b-3e24-186b-945a-3051f6f3a95b
Hope this helps.
Cheers,
David