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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply