SQL Server——有什么更好的替代方案可以改进长事务的性能，包括大量插入?

I have a scenario where a user action on screen results in new records getting created in about 50 different tables, real-time. The design of the use case is such that the new records that are created as a result of a user action - is required immediately for the user to make changes. So no possibility of offline or delayed creation.I have a scenario where a user action on screen