If Total Memory >= Target Memory ------> Represents Memory Pressure

Total Memory < Target Memory ------> Represents No pressure.

So Instance 4 is not experiencing any mem pressures. But the other 3 are experiencing Mem Pressure.

MSSQL$<instance >:Memory Manager\Total Server Memory (KB): This indicates the current

size of the buffer pool.

MSSQL$<instance >:Memory Manager\Target Server Memory (KB): This indicates the ideal

size for the buffer pool. Total and Target should be almost the same on a server with no

memory pressure that has been running for a while. If Total is significantly less than Target,

then it’s likely that SQL Server cannot grow the buffer pool due to memory pressure, in

which case you can investigate further