We have recently implemented TDE and backup compression is also enabled. Before TDE backup used to take about 20min but now it takes about one hour.
I have set
@MaxTransferSize to 3MB, 2MB, 1MB and 0.5MB but didn't make any difference time wise, database is 90GB of size and it is SQL Server 2016 SP1 CU4.
We using Ola's Maintenance Solution/Scripts to backup the database. Any idea why it is taking 3x longer when TDE enabled please?