Do you have statistics on your cpu usage and runqueue prior to encryption?
On Thu, Jun 7, 2018 at 11:36 AM, Arun Chugh <arun.chugh1610@xxxxxxxxx>
We are using TDE for encryption and also getting the wait event "CPU+wait
for CPU" ... As an evidence we decrypt the database and it behaviour back
to normal as it was prior to encryption.
On Thu, Jun 7, 2018, 09:31 Tim Gorman <tim.evdbt@xxxxxxxxx> wrote:
What evidence do you have that TDE has affected performance 40-50%?
Can you prove that there has not been a change in execution plans?
On 6/6/18 21:51, Arun Chugh wrote:
We have encrypted almost all the datafiles of the database, post that
the performance of the database degraded to almost 40-50%
Could anyone suggest what is the other alternative method that we can use
in order to secure data with bit performance impact.