SYMPTOMS
In Microsoft SQL Server 2005, you query data from the
sys.dm_os_ring_buffers SQL Server Operating System-related dynamic management view. When you do this, the following symptoms occur in the XML output of the
record column:
- The value of the UserModeTime element is displayed as the value of the KernelModeTime element.
- The value of the KernelModeTime element is displayed as the value of the UserModeTime element.
This problem occurs only in the rows that have the
RING_BUFFER_SCHEDULER_MONITOR value in the
ring_buffer_type column.
For example, the XML output of the
record column may be displayed as follows.
<Record id = "12962" type ="RING_BUFFER_SCHEDULER_MONITOR" time ="2051487332">
<SchedluerMonitorEvent>
<SystemHealth>
<ProcessUtilization>0</ProcessUtilization>
<SystemIdle>99</SystemIdle>
<UserModeTime>0</UserModeTime>
<KernelModeTime>156250</KernelModeTime>
<PageFaults>0</PageFaults>
<WorkingSetDelta>0</WorkingSetDelta>
<MemoryUtilization>53</MemoryUtilization>
</SystemHealth>
</SchedluerMonitorEvent>
</Record>
However, you expect the XML output of the
record column to be displayed as follows.
<Record id = "12962" type ="RING_BUFFER_SCHEDULER_MONITOR" time ="2051487332">
<SchedluerMonitorEvent>
<SystemHealth>
<ProcessUtilization>0</ProcessUtilization>
<SystemIdle>99</SystemIdle>
<UserModeTime>156250</UserModeTime>
<KernelModeTime>0</KernelModeTime>
<PageFaults>0</PageFaults>
<WorkingSetDelta>0</WorkingSetDelta>
<MemoryUtilization>53</MemoryUtilization>
</SystemHealth>
</SchedluerMonitorEvent>
</Record>