To reduce the load on the DB caused by hangfire as revealed by the query store reports (extremely high # executions, memory usage, etc.), try to reduce the HF server count and optimize polling intervals without sacrificing waiting time for users interacting with the system and without having long-running jobs preventing high priority tasks from running.
hangfire_investigations.xlsx
To reduce the load on the DB caused by hangfire as revealed by the query store reports (extremely high # executions, memory usage, etc.), try to reduce the HF server count and optimize polling intervals without sacrificing waiting time for users interacting with the system and without having long-running jobs preventing high priority tasks from running.
hangfire_investigations.xlsx