Happy to report that the Memory Grants Pending counter was added in v10.0.13.
Note: The perfmon counter isn't cumulative, so it's only captured when SQL Monitor samples when a memory grant is pending. (This particular sample happens fairly frequently at every 15 seconds.)
Hi all!
Happy to report that the Memory Grants Pending counter was added in v10.0.13.
Note: The perfmon counter isn't cumulative, so it's only captured when SQL Monitor samples when a memory grant is pending. (This particular sample happens fairly frequently at every 15 seconds.)