Currently rename across databases takes an X lock on the target database. It should be possible to downgrade this lock to take an IX lock instead, which has better performance by allowing other operations to proceed concurrently.

Note that downgrading the lock to IX requires changing the code that generates a temporary namespace for renaming to use a retry loop, instead of the current logic which takes advantage that no-one else can generate a conflicting name.