Memory queues support for SQL Server job storage implementation for Hangfire
Install-Package Hv.Hangfire.SqlServer.Memory
If you are using only default queue, call the UseMemoryQueues method just after UseSqlServerStorage method call and pass the path pattern as an argument.
GlobalConfiguration.Configuration
.UseSqlServerStorage("<connection string or its name>")
.UseMemoryQueues(@"hangfire-{0}");
To use multiple queues, you should pass them explicitly:
GlobalConfiguration.Configuration
.UseSqlServerStorage("<connection string or its name>")
.UseMemoryQueues(@"hangfire-{0}", "critical", "default");