Recently I got sql alerts from one of QA servers, every 2 or 3 hours.
DESCRIPTION: The SQL Server performance counter 'Memory Grants Pending' (instance 'N/A') of object 'Memory Manager' is now above the threshold of 0.00 (the current value is 1.00).COMMENT: Ideally there should be no processes waiting for memory and this should = 0. More memory is needed if this value is >=1.
This is a QA server not many people using it. The application runs fine. and this alert pops up every 2 to 3 hours, I cannot find anything abnormal in sql logs, windows logs. No specific jobs running at that time either.
How can I find the bottom cause of this alert?
Thanks