Note that you will get some logging as pages change and they are decrypted. If...

Awesome thanks Steve!   I met you once at PASS a couple years ago at Red-Gate booth- you were really nice-- as well online too answering questions  😀

Just checking if any one knew the answer to this again 🙂  I'd like to reduce my downtime...  most of the time TDE is set it and forget it....exception keeping...

Have you confirmed with  sp_configure if it updated 

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/server-configuration-options-sql-server?view=sql-server-2017

I agree with Jeff creating some script that captures blocking into a table, that's probably easier if you are unfamiliar w/SQL Sentry - which is great if you know how...

This one is not so popular 🙁 

I'm going to go with

IF UPDATE(status)

begin

update example_table

set flag =1

from example_table et

where status = 'X'

and EXISTS...

I agree w/Muthukkumaran

It  really depends on your workload.  For example I worked at place where maxdop  was set at 1, this was due to too much parallelism recommended...

I ran into your post via google search...  There is SQLrelay ... performance may not be on par w/ScaleArc for a sql proxy type software.  maybe HAProxy also ?

I agree with Eric M Russell's comment about linked servers. We used to use linked servers all over the place and...