May 10, 2012 at 1:34 pm
My os info DMV and performance counter DMVs are not reporting same info. in fact performance counter DMV (and in Perfmon) both return 0 as Target and Total server memory.
1) do i simply need to rebuild performance counters? ()
2) does SQL use perf counters in its memory management programming or the sys info data? I am seeing much higher than normal I/O since this occured. (pagelatch wait times increased by an order of magnitude.
QUERY:
SELECT 'BufferPoolfromOSInfo' [Source]
,(bpool_committed*8)/1024.0 as BPool_Committed_MB
, (bpool_commit_target*8)/1024.0 as BPool_Commit_Tgt_MB,(bpool_visible*8)/1024.0 as BPool_Visible_MB
FROM sys.dm_os_sys_info
UNION ALL
SELECT 'BufferPoolfromOSperfCounters' [Source]
,cntr_value as Mem_KB, cntr_value/1024.0 as Mem_MB
, (cntr_value/1048576.0) as Mem_GB
FROM sys.dm_os_performance_counters
WHERE counter_name = 'Target Server Memory (KB)'
RESULTS:
SourceBPool_Committed_MBBPool_Commit_Tgt_MBBPool_Visible_MB
BufferPoolfromOSInfo226304.000000226304.000000226304.000000000
BufferPoolfromOSperfCounters0.0000000.0000000.000000000
May 13, 2012 at 10:21 am
Could the OS performance monitor be reporting on the applications besides SQL Server? Some servers are nearly dedicated to SQL Server. Windows Small Business servers lend themselves to other things (like file servers, application servers, etc.).
If it were me, I'd try other DMVs to see if the cause of the discrepancy can be revealed.
Is this a virtual environment? Could the CPU and memory be getting used by other things?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply