Microsoft KB Archive/922123

= BUG: The value of the UserModeTime element is displayed as the value of the KernelModeTime element in the XML output of the record column in SQL Server 2005 =

Article ID: 922123

Article Last Modified on 11/20/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Standard Edition
 * Microsoft SQL Server 2005 Enterprise Edition
 * Microsoft SQL Server 2005 Developer Edition
 * Microsoft SQL Server 2005 Express Edition
 * Microsoft SQL Server 2005 Express Edition with Advanced Services
 * Microsoft SQL Server 2005 Workgroup Edition
 * Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
 * Microsoft SQL Server 2005 Enterprise X64 Edition
 * Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
 * Microsoft SQL Server 2005 Standard X64 Edition

-



Bug #: 437288 (SQLBUDT)



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.    0 99 0 156250 0 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 = &quot;12962&quot; type =&quot;RING_BUFFER_SCHEDULER_MONITOR&quot; time =&quot;2051487332&quot;> <SchedluerMonitorEvent> <SystemHealth> 0</ProcessUtilization> 99</SystemIdle> 156250</UserModeTime> 0</KernelModeTime> 0</PageFaults> <WorkingSetDelta>0</WorkingSetDelta> <MemoryUtilization>53</MemoryUtilization> </SystemHealth> </SchedluerMonitorEvent> </Record>

<div class="cause_section">

CAUSE
This problem occurs because the XML output incorrectly reverses the kernel mode time value and the user mode time value.

<div class="status_section">

STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the &quot;Applies to&quot; section.

<div class="references_section">