Skip to content

tpm difference between normal user and sysadmin #391

Answered by sm-shaw
tosim asked this question in Q&A
Discussion options

You must be logged in to vote

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.

Replies: 2 comments

Comment options

You must be logged in to vote
0 replies
Comment options

You must be logged in to vote
0 replies
Answer selected by sm-shaw
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Category
Q&A
Labels
None yet
2 participants
Converted from issue

This discussion was converted from issue #389 on July 14, 2022 13:12.