Database backup with TDE

sakuraime 2,341 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.
14,492 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AmeliaGu-MSFT 14,006 Reputation points Microsoft External Staff
    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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.