|
|
|
SSC-Enthusiastic
 
Group: General Forum Members
Last Login: Tuesday, March 16, 2010 5:45 AM
Points: 167,
Visits: 137
|
|
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
|
|
|
|
|
SSCarpal Tunnel
Group: General Forum Members
Last Login: Today @ 5:50 AM
Points: 4,712,
Visits: 3,093
|
|
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.
|
|
|
|
|
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, March 16, 2010 5:45 AM
Points: 167,
Visits: 137
|
|
Many Thanks for your reply...
subban
|
|
|
|
|
SSCommitted
Group: General Forum Members
Last Login: Today @ 7:13 AM
Points: 1,790,
Visits: 2,459
|
|
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,
TheSQLGuru
SQL Server MVP
|
|
|
|
