we have a SQL 2017 with CU23 and I know the CU is 27 now.
we have a performance problem that when we insert a record to a very large table, 155880134 rows, even a select count(*) seems return slowly and when it is running the wait type is (1ms)HADR_SYNC_COMMIT.
usually other than
1) change sync type from sync to async.
2) change that table to use table partitioning.
3) make the tempdb growth rate less frequently.
what else we can do.