MSSQL DeadLock with workerCount

Thank you for your reply.
I had this problem because I did this step: SonarQube upgrade to 7.3 version from 6.7.5v

Do you know the impact it makes if we remove the “unique” from this index?

Thank you