启用 TDE 对数据库性能有何影响? [英] What are impacts of TDE enabling on database performance?

问题描述

如果我在我的数据库上使用透明数据加密，对我的数据库性能有什么影响吗?是否会导致数据库索引出现问题?

If I use Transparent Data Encryption on my database, is there any impact on my db performance? Is it cause any problem for database indexing?

推荐答案

有些人已经对此进行了测试(参见 此处，此处、此处和此处)并给出了一些通用建议(见此处和此处).似乎普遍的看法是影响约为 3-5%.但是 3-5% 是什么?如果那是 CPU 并且您的工作负载已经受 CPU 限制，这是否可以接受?难道会更糟?如果这是 I/O 并且您已经遇到了 I/O 问题，它会杀死您的系统吗?谁知道?

Some folks have tested this (see here, here, here and here) and have given some generic advice (see here and here). Seems the common perception is that the impact is about 3-5%. But 3-5% of what? If that is CPU and your workload is already CPU-bound, is that acceptable? Could it be worse? If that is I/O and you're already having I/O issues, is it going to kill your system? Who knows?

确定它对您的性能有何影响的最佳方法是在您的环境中对其进行测试.有很多取决于"这里的因素不好笑.您应该针对您的数据库、您的硬件、您的网络、测试您的工作负载您的使用模式和备份程序.您可能会有人回来说这对我的表现造成了很大影响"或我什至没有注意到"，但您认为他们的情况与您的情况有多相似?

The best way you're going to determine what impact it will have on your performance is to test it in your environment. There are so many "it depends" factors here it's not funny. You should test your workload, against your database, on your hardware, over your network, with your usage patterns and backup procedures. You may have people coming back and saying "it hurt my performance a lot" or "I didn't even notice it" but how similar do you think their scenario is to yours?

这篇关于启用 TDE 对数据库性能有何影响?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！