{"action":"closed","issue":{"url":"https://api.github.com/repos/HangfireIO/Hangfire/issues/313","labels_url":"https://api.github.com/repos/HangfireIO/Hangfire/issues/313/labels{/name}","comments_url":"https://api.github.com/repos/HangfireIO/Hangfire/issues/313/comments","events_url":"https://api.github.com/repos/HangfireIO/Hangfire/issues/313/events","html_url":"https://github.com/HangfireIO/Hangfire/issues/313","id":58810914,"number":313,"title":"Expiration tablock hint and configurable CheckInterval","user":{"login":"travisblakeney","id":507449,"avatar_url":"https://avatars.githubusercontent.com/u/507449?v=3","gravatar_id":"","url":"https://api.github.com/users/travisblakeney","html_url":"https://github.com/travisblakeney","followers_url":"https://api.github.com/users/travisblakeney/followers","following_url":"https://api.github.com/users/travisblakeney/following{/other_user}","gists_url":"https://api.github.com/users/travisblakeney/gists{/gist_id}","starred_url":"https://api.github.com/users/travisblakeney/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/travisblakeney/subscriptions","organizations_url":"https://api.github.com/users/travisblakeney/orgs","repos_url":"https://api.github.com/users/travisblakeney/repos","events_url":"https://api.github.com/users/travisblakeney/events{/privacy}","received_events_url":"https://api.github.com/users/travisblakeney/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/HangfireIO/Hangfire/labels/sql","name":"sql","color":"bfd4f2"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-02-24T21:47:41Z","updated_at":"2015-03-19T13:02:25Z","closed_at":"2015-03-19T13:02:25Z","body":"When the ExpirationManager cleans up the expired records on Sql Server we are seeing an unnecessary amount of locking on the tables which is affecting the performance of our database when under load. We are wanting to submit a pull request with 2 changes.\r\n\r\n1. Remove the with (tablock) hint in the sql statement that is executed as part of the cleanup\r\n2. Add a configurable TimeSpan on the SqlServerStorageOptions class so that cleanup can be run more frequently.\r\n\r\nDo these sound like changes you would be happy accepting? \r\n\r\nIf you have any other suggestions or alternatives that would help with the cleanup please let us know.\r\n\r\n"}}