Let talk deadlock. Yes that’s what happens when you set the queue slot size and have workflows in the queue.
Simple example you have a database and you only want to run three jobs at once on the database. You would think that using a queue would be the way to do it and it is. The problem is that you can only have jobs run in the queue as soon as you add a workflow you can deadlock the jobs from running. This is because the workflow uses a slot.
The real problem is when you have 100 databases. You need to then setup 100 queues that you use for jobs and if you want to use a queue to hold the database queue you need another 100 queues.Is this just a bad design or is there some reason to count the workflow as a slot?