I am experiencing frequent deadlocks in the dbp.Activity_Search table of my workflow database as new activities are written and deleted during workflow processing. I have just discovered that this table contains over 2,000,000 million old rows (From 2017). This is prior to my tenure and I am not sure how they got "stuck" in this table and never deleted. i believe theses rows are the culprit in my deadlocks.
Can I simply delete these rows without adversely impacting my production workflow server? If not, how to proceed to clean up this table?