HangFire.SqlServer 1.7.0-rc1

Hangfire SQL Server Storage

SQL Server 2008+ (including Express), SQL Server LocalDB and SQL Azure storage support for Hangfire (background job system for ASP.NET applications).

This is a prerelease version of HangFire.SqlServer.
There is a newer version of this package available.
See the version list below for details.
Install-Package HangFire.SqlServer -Version 1.7.0-rc1
dotnet add package HangFire.SqlServer --version 1.7.0-rc1
paket add HangFire.SqlServer --version 1.7.0-rc1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

https://www.hangfire.io/blog/

1.7.0-rc1
• Added – `SqlServerStorageOptions.EnableHeavyMigrations` switch to automatically install even heavy migrations.
• Added – `Schema 7` migration to fix the `IX_HangFire_Set_Score` index to include the `Key` column.
• Added – `SqlServerStorageOptions.DisableGlobalLocks` property to avoid custom locking scheme.
• Added – `SqlServerStorageOptions.UsePageLocksOnDequeue` property to use less CPU consuming fetch.
• Changed – `Schema 6` migration is disabled by default for existing installations, because it may take too long.
• Changed – Don't throw an exception when using automatic migrations and current schema is newer than expected.
• Changed – Store arguments in the corresponding column in SQL Server again.
• Changed – Continue to use global locks by default in SQL Server storage.
• Changed – Bring `ExpirationManager` and `CountersAggregator` to their previous state.
• Changed – Monitoring API doesn't check state data to see state transition time.
• Changed – Update `CountersAggregator` to use clustered key for temp table.
• Fixed – Avoid unnecessary waits in state changer when job was already expired.
• Fixed – Cannot resolve the collation conflict in `CountersAggregator`.
• Ported – Merged updates from version 1.6.23.

1.7.0-beta3
• Changed – Short paths for the CreateExpiredJob method to avoid some round-trips.
• Changed – Allow to use zero-based poll interval when sliding invisibility timeout.
• Changed – Set `SqlParameter` types explicitly to not to duplicate query plans.
• Changed – Batch support for `AddToQueue` method when default provider is used.
• Changed – Check `FetchedAt` has expected value to prevent prolonging others' work.
• Changed – Use more recent Dapper 1.50.7 on all platforms except .NET Framework 4.5.
• Changed – Dapper package is internalized now even on .NET Core to avoid possible conflicts.
• Ported – Merged updates from version 1.6.21 and 1.6.22.
     
1.7.0-beta2
• Added – Blocking fetch support for sliding expiration-based fetch to avoid excessive polling.
• Changed – Optimize sliding-expiration-based fetching to use even less CPU time.
• Changed – Use write reordering and fine-grained locking scheme to improve parallelism.
• Ported – Merged updates from versions 1.6.18 – 1.6.20.
   
1.7.0-beta1
• Added – Callback method to allow to open the database with impersonation (by @BjoernHund).
• Changed – Identity columns either converted to the `bigint` type, or entirely removed.
• Changed – Clustered indexes were organized according to the access patterns of their tables.
• Changed – Most of secondary indexes were either removed or made filtered.
• Fixed – Background processing stops when identity columns exceed the `Int32.MaxValue`.
• Fixed – Slowdown of scheduled jobs due to the missing index on the [Set] table.

Version History

Version Downloads Last updated
1.7.1 1,781 4/16/2019
1.7.0 24,955 3/29/2019
1.7.0-rc2 1,265 3/22/2019
1.7.0-rc1 1,463 3/15/2019
1.7.0-beta4 4,723 2/18/2019
1.7.0-beta3 135 2/15/2019
1.7.0-beta2 26,428 9/1/2018
1.7.0-beta1 44,833 3/2/2018
1.6.25 580 4/9/2019
1.6.24 5,128 3/27/2019
1.6.23 36,242 3/13/2019
1.6.22 159,858 1/25/2019
1.6.21 299,502 11/1/2018
1.6.20 419,470 7/31/2018
1.6.19 530,229 4/6/2018
1.6.18 5,945 4/5/2018
1.6.17 926,453 9/19/2017
1.6.16 70,079 9/2/2017
1.6.15 137,348 8/8/2017
1.6.14 198,369 6/16/2017
1.6.13 41,020 6/7/2017
1.6.12 349,443 3/22/2017
1.6.11 22,703 3/14/2017
1.6.10 11,112 3/13/2017
1.6.9 29,246 3/2/2017
1.6.8 207,255 12/21/2016
1.6.7 78,256 11/25/2016
1.6.6 111,082 10/13/2016
1.6.5 84,799 9/24/2016
1.6.4 69,732 8/30/2016
1.6.3 22,787 8/19/2016
1.6.2 35,359 8/5/2016
1.6.1 28,359 7/27/2016
1.6.0 17,535 7/15/2016
1.5.9 22,173 7/11/2016
1.5.8 28,072 6/17/2016
1.5.7 20,192 5/30/2016
1.5.6 54,374 4/22/2016
1.5.5 14,344 4/14/2016
1.5.4 28,904 3/22/2016
1.5.3 201,199 11/6/2015
1.5.2 19,706 10/15/2015
1.5.1 1,798 10/14/2015
1.5.0 21,017 10/1/2015
1.4.7 1,504 10/1/2015
1.4.6 20,514 8/29/2015
1.4.5 22,208 7/24/2015
1.4.4 736 7/23/2015
1.4.3 27,611 5/27/2015
1.4.2 9,075 5/6/2015
1.4.1 14,185 4/14/2015
1.3.4 43,435 2/4/2015
1.3.3 2,280 1/28/2015
1.3.2 899 1/27/2015
1.3.1 5,972 1/13/2015
1.3.0 4,407 12/10/2014
1.2.2 4,927 11/24/2014
1.2.1 567 11/22/2014
1.2.0 3,513 11/17/2014
1.1.1 13,143 9/5/2014
1.1.0 1,519 9/3/2014
1.0.2 4,353 7/1/2014
1.0.1 477 6/30/2014
1.0.0 531 6/30/2014
0.9.1 1,508 6/12/2014
0.9.0 481 6/7/2014
0.8.3 502 5/23/2014
0.8.2 437 5/21/2014
0.8.1 655 5/17/2014
0.8.0 1,368 5/2/2014
0.7.5 428 4/10/2014
0.7.4 373 4/7/2014
0.7.3 372 4/4/2014
0.7.1 358 4/1/2014
0.7.0 1,261 3/22/2014