May 13, 2012 at 4:13 am
When I try to monitor the sys.dm_os_performance counters "SQLServer:Buffer Node\Local node page lookups/sec" and "SQLServer:Buffer Node\Remote node page lookups/sec" they consistently show up as zero on all our servers. (2008 R2 SP1):
object_name counter_name instance_namecntr_valuecntr_type
SQLServer:Buffer NodeLocal node page lookups/sec 3 0 272696576
SQLServer:Buffer NodeRemote node page lookups/sec 3 0 272696576
SQLServer:Buffer NodeLocal node page lookups/sec 2 0 272696576
SQLServer:Buffer NodeRemote node page lookups/sec 2 0 272696576
SQLServer:Buffer NodeLocal node page lookups/sec 0 0 272696576
SQLServer:Buffer NodeRemote node page lookups/sec 0 0 272696576
SQLServer:Buffer NodeLocal node page lookups/sec 1 0 272696576
SQLServer:Buffer NodeRemote node page lookups/sec 1 0 272696576
Now, clearly, they shouldn't BOTH be zero! Is anyone else having the same issue? I can't find any documentation / blogs / cries for help out there from any other sufferers.
August 6, 2012 at 3:43 pm
I am seeing the same thing on one of my server I just looked at. The is a 4 processor (x 6 core each) box with 128 GB of RAM.
I agree with you, at lease one of the counters should have a value for the 4 NUMA / Buffer Nodes.
August 6, 2012 at 3:45 pm
Other Performance Counters:
The following counters are incremented when the 'get' call is made to the buffer pool to satisfy access to a specific database page.
Description
Buffer Node: Local node page lookups/sec
Buffer Node: Remote node page lookups/sec
April 10, 2013 at 1:02 pm
Yep, zeros for me, too.
I've got these counters added. All of them have values as expected except the local and remote lookups/sec. I've seen this behavior in SQL Server 2008 R2 and SQL Server 2008 R2 SP1, on Intel servers (2 and 4 NUMA node servers) and AMD servers (4 socket, 8 NUMA node servers).
\SQLServer:Buffer Node(*)\Database Pages
\SQLServer:Buffer Node(*)\Foreign Pages
\SQLServer:Buffer Node(*)\Free Pages
\SQLServer:Buffer Node(*)\Local node page lookups/sec
\SQLServer:Buffer Node(*)\Page Life Expectancy
\SQLServer:Buffer Node(*)\Remote node page lookups/sec
\SQLServer:Buffer Node(*)\Stolen Pages
\SQLServer:Buffer Node(*)\Target Pages
\SQLServer:Buffer Node(*)\Total Pages
November 22, 2013 at 9:43 am
I am also facing the same issue in SQL 2008 R2 SP2 . Please post if anyone find solution for this problem.
Thanks in advance.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy