I look at my code's logs, and see that a query to delete something which occurs like 200 times a day, sometimes times-out. I have no clue to how to debug this. Because it's a very random behavior. Nothing is changed accept that the size of database is growing under operation. This is a pseudo-log:
8/20/2016 9:31:13 AM-Error: The wait operation timed out at Repository.UserHistoryRepository.Delete(15);
As you can see, this is the only information that I have. That a delete operation is timed-out at time X. I'm stuck at how to debug this and find out the cause. I don't know even from where to start.
I'm using SQL Server 2014.