Currently I am configured with SQL server. I am in the process of purchasing the pro version of HangFire
Right now we about 20 servers with 80 agents/workers on each. When I get to that amount of workers, I am seeing a performance degradation and errors occurring. Some of the Hangfire tables get locked and I am seeing errors.
I am getting the following 2 errors:
System.InvalidOperationException: Could not get a value of the job parameterCurrentUICulture
. See inner exception for details. ---> System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool
System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
I was thinking of using RabbitMQ with SQL server to help with the database performance. Has anyone have had experience with it and what are some thing I can expect using it.