K
Keith Sudbury
Guest
I probably should have expanded on the definition of "heavy updates" a bit. Those numbers were based on a worst case scenario for one of the first large databases to implement TDE... loading about 10 million rows (several GB of data) into an encrypted table. As Rob says, in the real world it will depend on how often your encrypted tables/indexes are written or read from disk. But unless you are running close to the edge on your current hardware or just decide to encrypt everything... you aren't likely to see a noticeable performance difference. Certainly not compared to the value that TDE provides.
Continue reading...
Continue reading...