In pre-11.9.2 releases, the simultaneous use of Dynamic SQL by a large number of users performs poorly, largely due to contention on system tables in tempdb. In version 11.9.2, the contention problems have been eliminated, and the performance of the prepare and deallocate statements has been significantly improved. There are no user interface changes. All changes are internal, so applications do not need to be modified.
