InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 24 May 2012 13:25:17 GMT20http://www.sqlservercentral.com/Forums/Topic822279-360-1.aspxit 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.Wed, 25 Nov 2009 07:43:44 GMTTheSQLGuruhttp://www.sqlservercentral.com/Forums/Topic822279-360-1.aspxMany Thanks for your reply...Wed, 25 Nov 2009 02:00:20 GMTSubhash-63067http://www.sqlservercentral.com/Forums/Topic822279-360-1.aspx[quote][b]Subhash-63067 (11/20/2009)[/b][hr]Hi All,What should be the ideal value for [b]SQL Server: Memory Manager – Memory Grant Pending [/b] performance counter?I have a server which showing >20 for this always.[/quote]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.Tue, 24 Nov 2009 02:10:09 GMTSQL Kiwihttp://www.sqlservercentral.com/Forums/Topic822279-360-1.aspxHi All,What should be the ideal value for [b]SQL Server: Memory Manager – Memory Grant Pending [/b] performance counter?I have a server which showing >20 for this always.Fri, 20 Nov 2009 05:31:17 GMTSubhash-63067