I’m trying to understand the meaning of the SQL Server config options. I don’t see a document that just explains them - some are in release notes, others in examples.
I’m using Hangfire to schedule sending out some emails, and they will be sent perhaps twice a day - for example, 7 AM and 7 PM. So I don’t need fine grained checking of a schedule.
It looks like the recommended/default is:
CommandBatchMaxTimeout = TimeSpan.FromMinutes(5), SlidingInvisibilityTimeout = TimeSpan.FromMinutes(5), QueuePollInterval = TimeSpan.Zero,
Does this mean it will constantly be polling the database for the tasks? Every 5 minutes? I’m not getting with QueuePollInterval of TimeSpan.Zero means.
Should I be doing something like QueuePollInterval = TimeSpan.FromMinutes(30) or TimeSpan.FromMinutes(60) if I’m using a somewhat sparse schedule like this? Is this what would make it hit poll the database minimally? Are there any downsides?