Home Dashboard Directory Help

sys.dm_os_performance_counters by Derek Czarny


 as By Design Help for as By Design

Sign in
to vote
Type: Bug
ID: 788568
Opened: 5/24/2013 7:41:45 AM
Access Restriction: Public
User(s) can reproduce this bug


The SQL Server 2012 SP1 DMV sys.dm_os_performance_counters for object_name SQLServer:Buffer Manager, counter_name Target pages doesn't seem to be reporting the proper value. The Target pages should be multiplied by 8, which would equal the Memory Manager - Target Server Memory (KB). When the cntr_type = 65792, that should be an absolute value.
Sign in to post a comment.
Posted by Microsoft on 7/2/2013 at 4:29 PM
Hi Derek,

The performance counter SQLServer:Buffer Manager\Target Pages is not tied to SQLServer:Memory Manager\Target Server Memory (KB). It is only meaningful when the database contains both traditional row based data and the column store index, and both are cached in memory by the buffer pool and the column store object pool respectively. In that case the sizes of these two caches will be controlled by the memory broker which will be setting the buffer manager target pages to shrink or allow growth of the buffer pool. If column store object pool is not used then the buffer manager target pages is set to the max possible size that the buffer manager can theoretically grow to for the current SKU.

Hope this helps!
George Reynya
SQL Server
Sign in to post a workaround.