Hi,

For OLTP system, a lot of contention for tempdb system tables when
repeatedly create and drop temporary tables. Is there any way to
minimize the lock contention in tempdb tables such as sysobjects,
syscolumns, and sysindexes (except creating the tables at the start of
the application)?

Does data row lock apply to those tables can solve the problems?

Thanks for your attention!

Raymond