Memory grants pending root cause
-
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
-
check "sql-server-diagnostic-information-queries-detailed-day-17" Query #40!
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Thanks, I know this query,
But when I run it , it returns 0.
How can I keep track of it , and what query to use to find out what caused this value >1
Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply