Queries getting queued but pool has enough memory
Except for lack of memory, what would cause a query to spend time in resource queue?
An application's queries should run faster than they are based on tests, but because it is spending time in queue (resource_acquisitions - queue_entry_timestamp vs acquisition_timestamp) it's duration is getting extended (e.g. 15 minutes in queue, 1 minute execution).
Our memory and CPU levels are below threshold, only issue we have is IO, would that affect this?