Hello,
We are receiving following error in our Sql server which hosted for 3rd party monitoring application wiht 2 databases running.
A timeout occurred while waiting for memory resources to execute the query in resource pool 'internal' (1). Rerun the query.
We have Sql Server 2014 SP3-CU4 , CPU 4, Total Memory: 8 GB and MAX MEMORY 6 GB.
I don't want to restart the server and fix the issue but need to troubleshoot to fix it.
I checked following:
Buffer Cache Hit Ratio is 100

CPU Pressure from sys.dm_os_schedulers:
