sys.dm_os_performance_counters - by Derek Czarny

Status : 

  By Design<br /><br />
		The product team believes this item works according to its intended design.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


1
0
Sign in
to vote
ID 788568 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 5/24/2013 7:41:45 AM
Access Restriction Public

Description

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