We have been running Hangfire for a couple years in production now, but we occasionally have an issue where Hangfire is flooding our SQL server with open transactions that never close. This spikes the SQL server’s CPU to 100%. Prior to today, the last occurrence was 6 months ago, but it was more frequent in the past.
We are able to kill all the offending transactions by doing a iisreset on whichever webserver is misbehaving.
For reference, we have 5 webservers all running against the same hangfire storage. Each of the servers has had the problem in the past
Has anyone else had this problem and/or know how to solve it?