Please guide me on this deadlock exception, I am getting this for CMS_SettingsKey table.
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
Transaction (Process ID 137) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
I am using this to get VisitorCount.
It is difficult to say what causes the deadlock without seeing the code. Could you post the code accessing the settings? Do you use transactions in the code? Also, not sure I understood what is the VisitorCount you are referring to?
Please, sign in to be able to submit a new answer.