I am getting Deadlocks on the table TW_PROD_SEARCH.
Has anyone had this problem before? if so what was the cause...how did yo fix it?
it is web api table, only use by web users.
interesting, how can you involve the deadlock?
1, deadlock can happen anytime.
2, you can choose a vitim manually with a right click on a process select "Kill Process"(in 'Activity monitor' under management) or SQL server will choose it for you.
if the TW_PROD_SEARCH is too large. you can delete some old records.
even
truncate table TW_PROD_SEARCH
it will be populated by web api.
or you can manually populate it by copies with different spid