3.1.4.2.2.1.3.40.1 Columns

  • Article

The DISCOVER_MEMORYUSAGE rowset contains the following columns.

Name

Type

Restriction

Description

MemoryID

xsd:unsignedLong

A number identifying the memory.

MemoryName

xsd:string

The name of the object owning the memory.

SPID

xsd:unsignedInt

Yes

The session that allocated the memory. Zero indicates memory not tied to a specific session.

CreationTime

xsd:dateTime

Either "the time the object was created" or "the time the memory was allocated."

BaseObjectType

xsd:unsignedInt

Yes

This is a number describing the type of the object. Objects with the same BaseObjectType have the same type.

MemoryUsed

xsd:unsignedLong

Yes

This is the current size of the object, which can be less than the memory allocated for use by the object.

MemoryAllocated

xsd:unsignedLong

The amount of memory allocated for use by the object, which can be greater than the amount of memory actually used by the object.

MemoryAllocBase

xsd:unsignedLong

The bytes initially allocated for the object itself (excluding additional allocations for object contents).

MemoryAllocFromAlloc

xsd:unsignedLong

The memory allocated for the contents of this object.

ElementCount

xsd:unsignedInt

For a container object, this is the number of objects contained by that object.

Shrinkable

xsd:boolean

Yes<302>

A Boolean that indicates if the memory is shrinkable (can be evicted due to memory pressure). If true, the memory is shrinkable; if false, the memory is not shrinkable.

ObjectParentPath

xsd:string

A string identifying the full path of this object.

ObjectId

xsd:string

A string identifying the object.

Group

xsd:string

The name of the group. The system tracker name is $System.

The rowset is not sorted.

The response has the following definition.

       <xsd:element name="root">
         <xsd:complexType>
           <xsd:sequence minOccurs="0" maxOccurs="unbounded">
             <xsd:element name="row" type="row" />
           </xsd:sequence>
         </xsd:complexType>
       </xsd:element>
       <xsd:complexType name="row">
         <xsd:sequence>
           <xsd:element sql:field="MemoryID" name="MemoryID" type="xsd:unsignedLong" 
                            minOccurs="0" />
           <xsd:element sql:field="MemoryName" name="MemoryName" type="xsd:string" 
                            minOccurs="0" />
           <xsd:element sql:field="SPID" name="SPID" type="xsd:unsignedInt" minOccurs="0" />
           <xsd:element sql:field="CreationTime" name="CreationTime" type="xsd:dateTime" 
                            minOccurs="0" />
           <xsd:element sql:field="BaseObjectType" name="BaseObjectType" 
                            type="xsd:unsignedInt" minOccurs="0" />
           <xsd:element sql:field="MemoryUsed" name="MemoryUsed" type="xsd:unsignedLong" 
                            minOccurs="0" />
           <xsd:element sql:field="MemoryAllocated" name="MemoryAllocated" 
                            type="xsd:unsignedLong" minOccurs="0" />
           <xsd:element sql:field="MemoryAllocBase" name="MemoryAllocBase" 
                            type="xsd:unsignedLong" minOccurs="0" />
           <xsd:element sql:field="MemoryAllocFromAlloc" name="MemoryAllocFromAlloc" 
                            type="xsd:unsignedLong" minOccurs="0" />
           <xsd:element sql:field="ElementCount" name="ElementCount" type="xsd:unsignedInt" 
                            minOccurs="0" />
           <xsd:element sql:field="Shrinkable" name="Shrinkable" type="xsd:boolean" 
                            minOccurs="0" />
           <xsd:element sql:field="ObjectParentPath" name="ObjectParentPath" type="xsd:string" 
                            minOccurs="0" />
           <xsd:element sql:field="ObjectId" name="ObjectId" type="xsd:string" 
                            minOccurs="0" />
           <xsd:element sql:field="Group" name="Group" type="xsd:string" 
                            minOccurs="0" />
         </xsd:sequence>
       </xsd:complexType>