That may be true I'm still pretty new to SQL and we migrated from a physical server to a virtual server which I'm sure is impacting performance do to storage not be the same setup as the physical box.

We also moved the server from a location that has less the a millisecond latency to 30ms round trip. They also didn't match the cores of the physical server in the virtual server.

But from what I have read the increase in CPU overhead b/c of TDE being enabled, which is what I was trying to say goes up depending on the workload of the server. The workload this server is seeing is having around 500 users connecting to it all day during business hours getting data ect.

I am still very appreciative to all the thoughtful responses and I am learning all the time.

Thanks again!

Have a Happy Thanksgiving!