Have an odd problem, we’ve been using hangfire for months with no problem, yesterday around midnight UTC the following query started running about 150 times/second and has been doing it consistently ever since.
SELECT top 1 Value
WHERE [Key] = @key
AND Score BETWEEN @from AND @to
ORDER BY Score
I see the query is part of Hangfire.SqlServer.SqlServerConnection.GetFirstByLowestScoreFromSet.
The number of times the query is being executed seems excessive, but I have no idea what triggers the query and why it would suddenly start doing this.
I have confirmed with my colleagues that no changes were made to the servers or code anytime near the time this began.