HangFire.SqlServer 1.6.14

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).

Install-Package HangFire.SqlServer -Version 1.6.14
dotnet add package HangFire.SqlServer --version 1.6.14
paket add HangFire.SqlServer --version 1.6.14
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

http://hangfire.io/blog/
   
1.6.14
• Added – `SqlServerStorageOptions.SlidingInvisibilityTimeout` to fetch jobs without using transaction.
• Fixed – Transaction log is full due to 'ACTIVE_TRANSACTION' by enabling to use new non-transactional fetch.
• Fixed – `SqlServerJobQueueMonitoringApi` can't cause READ UNCOMMITTED isolation level to leak on SQL Server 2012 or earlier.
• Fixed – Add missing `SqlServerStorage(DbConnection, SqlServerStorageOptions)` constructor.
   
1.6.13
• Fixed – Don't hide errors occurred while running SQL migrations.
• Fixed – `KeyNotFoundException` when accessing Deleted Jobs page in Dashboard.
• Fixed – `SqlServerDistributedLock` leaks connections, when lock acquisition is failed.
   
1.6.9
• Fixed – `TimeoutException` on large arguments or large batches via `SqlServerOptions.CommandTimeout`.

1.6.8
• Fixed – Use `long` where possible instead of `int` for background job identifiers, full support will be in 1.7.0.
   
1.6.7
• Fixed – Validation added to avoid "An invalid application lock time-out" exceptions (by t0mburton).
   
1.6.6
• Fixed – SqlServerJobQueue class doesn't use obsolete InvisibilityTimeout parameter anymore.
   
1.6.5
• Fixed – Different timeout issues after making performance optimizations.
• Fixed – SQL timeouts while getting a connection, when using default settings and >= 8 CPU cores.
• Fixed – ExpirationManager is bloated by SqlError instances, when there are a lot of messages from server.
• Fixed – Counters query returned inconsistent results during CountersAggregator executions.
• Performance – Added missing NOLOCK hint for monitoring queries when using SqlServer-based queues.
• Performance – ExpirationManager is forced to use index seek operations for cascade deletions.
• Performance – CountersAggregator now uses clustered index scan to issue less logical reads.
• Performance – Paging queries in dashboard now use CTEs to utilize less logical reads.
   
1.6.4
• Fixed – `SqlConnection` object leaks when using nested distributed locks (in batches and continuations).

1.6.3
• Fixed – Prevent `ExpirationManager`'s command from timing out, when there are a lot of records.
• Fixed – `CountersAggregator` issue introduced in 1.6.2, that causes slow record aggregation.
• Fixed – Add `XLOCK` hint for `CountersAggregator` query to prevent deadlocks on lock escalation.
   
1.6.2
• Changed – `JobExpirationCheckInterval` property value now defaults to 30 minutes.
• Fixed – Excessive blocking when expiring records in `State` and `JobParameters` tables.
• Fixed – Migration script `Install.sql` was deadlocked by itself, leading to errors on startup.

1.6.0
• Added – .NET Core support for Hangfire.Core and Hangfire.SqlServer packages (`netstandard1.3` target).
• Added – Zero latency processing when client and server reside in the same process (by @bgurmendi).
• Changed – `SqlServerStorage` class constructor now takes `DbConnection` instances (by @tystol).
• Changed – `SqlServerObjectsInstaller` class is public now (by @vbfox).
• Changed – Update Dapper to 1.50.1 version.
• Fixed – Drop constraints on Server.Id prior to altering it to avoid conflicts.

Version History

Version Downloads Last updated
1.6.17 21,608 9/19/2017
1.6.16 20,662 9/2/2017
1.6.15 32,354 8/8/2017
1.6.14 (current version) 82,436 6/16/2017
1.6.13 22,180 6/7/2017
1.6.12 167,914 3/22/2017
1.6.11 14,656 3/14/2017
1.6.10 7,935 3/13/2017
1.6.9 15,494 3/2/2017
1.6.8 125,498 12/21/2016
1.6.7 49,088 11/25/2016
1.6.6 70,071 10/13/2016
1.6.5 64,396 9/24/2016
1.6.4 42,192 8/30/2016
1.6.3 14,995 8/19/2016
1.6.2 26,395 8/5/2016
1.6.1 22,887 7/27/2016
1.6.0 13,690 7/15/2016
1.5.9 9,676 7/11/2016
1.5.8 20,344 6/17/2016
1.5.7 15,541 5/30/2016
1.5.6 44,102 4/22/2016
1.5.5 10,709 4/14/2016
1.5.4 20,067 3/22/2016
1.5.3 143,317 11/6/2015
1.5.2 12,389 10/15/2015
1.5.1 1,344 10/14/2015
1.5.0 11,195 10/1/2015
1.4.7 1,181 10/1/2015
1.4.6 18,309 8/29/2015
1.4.5 17,152 7/24/2015
1.4.4 489 7/23/2015
1.4.3 21,613 5/27/2015
1.4.2 7,922 5/6/2015
1.4.1 11,918 4/14/2015
1.3.4 38,947 2/4/2015
1.3.3 1,863 1/28/2015
1.3.2 673 1/27/2015
1.3.1 5,380 1/13/2015
1.3.0 3,786 12/10/2014
1.2.2 3,295 11/24/2014
1.2.1 375 11/22/2014
1.2.0 3,251 11/17/2014
1.1.1 12,137 9/5/2014
1.1.0 1,286 9/3/2014
1.0.2 3,849 7/1/2014
1.0.1 291 6/30/2014
1.0.0 281 6/30/2014
0.9.1 1,074 6/12/2014
0.9.0 287 6/7/2014
0.8.3 281 5/23/2014
0.8.2 209 5/21/2014
0.8.1 282 5/17/2014
0.8.0 1,113 5/2/2014
0.7.5 232 4/10/2014
0.7.4 183 4/7/2014
0.7.3 174 4/4/2014
0.7.1 164 4/1/2014
0.7.0 605 3/22/2014