November 20, 2009 at 5:31 am
Hi All,
What should be the ideal value for SQL Server: Memory Manager – Memory Grant Pending performance counter?
I have a server which showing >20 for this always.
subban
November 24, 2009 at 2:10 am
Subhash-63067 (11/20/2009)
Hi All,What should be the ideal value for SQL Server: Memory Manager – Memory Grant Pending performance counter?
I have a server which showing >20 for this always.
The ideal value would be zero.
Over 20 is scary - you should investigate. Without much more detail, it is quite impossible to be sure whether the cause is bad database design, poor configuration, or simply not having sufficient memory in the server.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
November 25, 2009 at 2:00 am
Many Thanks for your reply...
subban
November 25, 2009 at 7:43 am
it has been my experience that memory grants is one of the last things you should be concerned about. there are almost always huge amounts of low-hanging performance fruit to address first. even better is that fixing those other things (bad data structures, poor indexing, stale stats, fragmentation, suboptimal queries, etc,etc,etc) often make the memory grant 'problem' go away too.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply