3.1.4.2.2.1.3.40.1 Columns
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>