A timeout occurred while waiting for memory resources to execute the query in resource pool 'internal' (1). Rerun the query.

Question

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:

Answer 1

The problem is that even if you can find where the memory is spent, it can be difficult to deal with it. Well, you can start to flush various caches, but that is not that much than restarting the machine. And if you do that, you could add more RAM while you are it.

But you could look at sys.dm_os_memory_clerks to see where the memory is spent.

Answer 2

Seems you have memory pressure outside your sql server. What else is running on the machine at that time?

Answer 3

Thanks Tibor.
Mostly Sql, WMI provider host and 3rd party tool application
My Total Server Memory and Target Server Memory are close so no Memory Pressure, right?

Answer 4

Seems more like internal memory pressure to me. 8 GB in total is not a lot...

Answer 5

Thanks Erland.
Agreed but how can i troubleshoot that it's a internal memory pressure?