Readcommited usage on MSMQ+SQLServer

sql-server
Tags: #<Tag:0x00007f8d7d54dde8>

#1

Hi,

First of all, as this is my first post. Thanks for the project, it’s amazing.

I am using Hangfire for a project, and running some load testing we have discovered that the query performed by SqlServerConnection.GetJobData (as most of other queries in this class) is using (readcommitedlock). As I have read in other post, this is required and desired.

However, I am not sure if this is also required when we are using MSMQ for fetching jobs. Ideally, there is no option with the transactional queues for getting the same job from 2 different workers.

Is this right? Could we improve performance and reduce database locks being able to remove the (readcommittedlock) for the SQLStorage when we are using MSMQ?

Thanks a lot,
Jesus