I am running a job which deletes data from 7 tables, 2 of which contains 10-20 lakhs of records. But the job get stuck at a point when deleting data from a particular table web_activity which holds only 42000 records. It takes 4 hours most of the times. But sometimes it takes only 7 minutes. If this is the issue of index then what happens on the day of 7 minute execution.

There are 4 other jobs that run parallel everyday and sometimes create blockings, but blocking is due to resource being utilized by other jobs.
What I am concerned about is how can I reduce the four hours for deletion of only 42000 records for web_activity table.

One more point: There are huge number of logical reads 2066225339. I am not sure if that is the cause or not
Please help as I am not pro as a DBA.

#SQL2012 #ProductionServer

While doing DBCC SHOWCONFIG for that tables it shows below data :

enter image description here