-
when i use sa user, the tpm can reach 400,000 both tests are after build schema successfully. |
Beta Was this translation helpful? Give feedback.
Replies: 2 comments
-
test on sqlserver 2017SE |
Beta Was this translation helpful? Give feedback.
-
Do you see contention on the LOCK_RW_CMED_HASH_SET spinlock? This link explains how to diagnose if this is the case https://techcommunity.microsoft.com/t5/datacat/sqlsweet16-episode-8-how-sql-server-2016-cumulative-update-2-cu2/ba-p/305384 If it is having sysadmin privilege can reduce this contention and improve throughput. |
Beta Was this translation helpful? Give feedback.
Do you see contention on the LOCK_RW_CMED_HASH_SET spinlock?
This link explains how to diagnose if this is the case https://techcommunity.microsoft.com/t5/datacat/sqlsweet16-episode-8-how-sql-server-2016-cumulative-update-2-cu2/ba-p/305384
If it is having sysadmin privilege can reduce this contention and improve throughput.