Database backup with TDE

sakuraime 2,321 Reputation points
2021-09-10T07:19:21.873+00:00

If the database is already 2019 CU5 , and with TDE . backup with setting MAXTRANSFERSIZE to 4MB will get more benefit on the performance ?

130965-image.png

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,114 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2021-09-13T06:25:30.01+00:00

    Hi sakuraime,
    I’m not quite sure that setting MAXTRANSFERSIZE to 4MB when taking TDE database backup will get more benefit on the performance. Compression will significantly increase CPU usage. I think it is better to take tests with different MAXTRANSFERSIZE setting to find the right setting for your TDE database. Please check Performance Impact of Compressing Backups which might be helpful.

    Best Regards,
    Amelia

    0 comments No comments