4 years ago a website was built using hangfire for the organisation that I have worked at for the last two years. The web dev team and anyone else involved in that project are long gone. And I am a SQL code not a web dev but am the one tasked with figuring this out.
We have had several recent issues with hangfire (we are on 1.5.3). Recently some of the hangfire jobs failed to run and we notice jobs were enqueuing for days. We read through the blogs on this. I wrote a script to drop and create the tables - except for schema and server. We tested it more than once in our staging environment. Everything was good. So we fired it off in LIVE. And then all queries on the hangfire.jobparameter table started taking 8+ seconds and the sql server is noe running at 90% when it usually runs at 20%
Here is what we see in SQL Profiler trace
exec sp_executesql N’select Value from [HangFire].JobParameter where JobId = @id and Name = @name’,N’@id nvarchar(4000),@name nvarchar(4000)’,@id=N’524244’,@name=N’Continuations’
Can anyone help us resolve this?