907,871

Downloads

3,906

Downloads of v 1.6.14

757

Average downloads per day

2017-06-16

Last published

Share on Social Networks

Hangfire SQL Server Storage

1.6.14

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

To install Hangfire SQL Server Storage, run the following command in the Package Manager Console

Install-Package HangFire.SqlServer

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.

Owners

Authors

Sergey Odinokov

Copyright

Copyright © 2013-2017 Sergey Odinokov

Tags

Dependencies

Version History

Version Downloads Last updated
Hangfire SQL... 1.6.13 6,728 Wednesday, June 7, 2017
Hangfire SQL... 1.6.12 82,474 Wednesday, March 22, 2017
Hangfire SQL... 1.6.11 10,416 Tuesday, March 14, 2017
Hangfire SQL... 1.6.10 6,117 Monday, March 13, 2017
Hangfire SQL... 1.6.9 12,092 Thursday, March 2, 2017
Hangfire SQL... 1.6.8 93,698 Wednesday, December 21, 2016
Hangfire SQL... 1.6.7 40,929 Friday, November 25, 2016
Hangfire SQL... 1.6.6 56,934 Thursday, October 13, 2016
Hangfire SQL... 1.6.5 55,925 Saturday, September 24, 2016
Hangfire SQL... 1.6.4 35,626 Tuesday, August 30, 2016
Hangfire SQL... 1.6.3 12,780 Friday, August 19, 2016
Hangfire SQL... 1.6.2 25,042 Friday, August 5, 2016
Hangfire SQL... 1.6.1 20,931 Wednesday, July 27, 2016
Hangfire SQL... 1.6.0 13,049 Friday, July 15, 2016
Hangfire SQL... 1.5.9 7,522 Monday, July 11, 2016
Hangfire SQL... 1.5.8 17,938 Friday, June 17, 2016
Hangfire SQL... 1.5.7 14,438 Monday, May 30, 2016
Hangfire SQL... 1.5.6 40,190 Friday, April 22, 2016
Hangfire SQL... 1.5.5 8,688 Thursday, April 14, 2016
Hangfire SQL... 1.5.4 18,114 Tuesday, March 22, 2016
Hangfire SQL... 1.5.3 131,941 Friday, November 6, 2015
Hangfire SQL... 1.5.2 11,774 Thursday, October 15, 2015
Hangfire SQL... 1.5.1 1,305 Wednesday, October 14, 2015
Hangfire SQL... 1.5.0 10,266 Thursday, October 1, 2015
Hangfire SQL... 1.4.7 1,127 Thursday, October 1, 2015
Hangfire SQL... 1.4.6 17,696 Saturday, August 29, 2015
Hangfire SQL... 1.4.5 16,664 Friday, July 24, 2015
Hangfire SQL... 1.4.4 448 Thursday, July 23, 2015
Hangfire SQL... 1.4.3 20,816 Wednesday, May 27, 2015
Hangfire SQL... 1.4.2 7,727 Wednesday, May 6, 2015
Hangfire SQL... 1.4.1 11,557 Tuesday, April 14, 2015
Hangfire SQL... 1.3.4 36,551 Wednesday, February 4, 2015
Hangfire SQL... 1.3.3 1,808 Wednesday, January 28, 2015
Hangfire SQL... 1.3.2 639 Tuesday, January 27, 2015
Hangfire SQL... 1.3.1 5,001 Tuesday, January 13, 2015
Hangfire SQL... 1.3.0 3,687 Wednesday, December 10, 2014
Hangfire SQL... 1.2.2 3,185 Monday, November 24, 2014
Hangfire SQL... 1.2.1 352 Saturday, November 22, 2014
Hangfire SQL... 1.2.0 3,219 Monday, November 17, 2014
Hangfire SQL... 1.1.1 12,003 Friday, September 5, 2014
Hangfire SQL... 1.1.0 1,250 Wednesday, September 3, 2014
Hangfire SQL... 1.0.2 3,774 Tuesday, July 1, 2014
Hangfire SQL... 1.0.1 269 Monday, June 30, 2014
Hangfire SQL... 1.0.0 249 Monday, June 30, 2014
HangFire SQL... 0.9.1 1,012 Thursday, June 12, 2014
HangFire SQL... 0.9.0 266 Saturday, June 7, 2014
HangFire SQL... 0.8.3 258 Friday, May 23, 2014
HangFire SQL... 0.8.2 189 Wednesday, May 21, 2014
HangFire SQL... 0.8.1 250 Saturday, May 17, 2014
HangFire SQL... 0.8.0 1,078 Friday, May 2, 2014
HangFire.SqlServer 0.7.5 211 Thursday, April 10, 2014
HangFire.SqlServer 0.7.4 162 Monday, April 7, 2014
HangFire.SqlServer 0.7.3 153 Friday, April 4, 2014
HangFire.SqlServer 0.7.1 146 Tuesday, April 1, 2014
HangFire.SqlServer 0.7.0 526 Saturday, March 22, 2014