Returns the DISCOVER_MEMORYUSAGE statistics for various objects allocated by the server.


This rowset can produce very large result sets. If the results cannot be displayed because they require more display memory than SQL Server Management Studio allows, the results are written to a temporary file, in the following default location:


Applies to: tabular models, multidimensional models

Rowset Columns

The DISCOVER_MEMORYUSAGE rowset contains the following columns.

Column name Type indicator Restriction Description
MemoryID DBTYPE_UI8 A number identifying the memory.
MemoryName DBTYPE_WSTR The name of the object owning the memory.
SPID DBTYPE_UI4 Yes The session that allocated the memory. Zero indicates memory not tied to a specific session.
CreationTime DBTYPE_DBTIMESTAMP Either "the time the object was created" or "the time the memory was allocated."
BaseObjectType DBTYPE_UI4 Yes This is a number describing the type of the object. Objects with the same BaseObjectType have the same type.
MemoryUsed DBTYPE_UI8 Yes This is the current size of the object, which may be less than the memory allocated for use by the object.
MemoryAllocated DBTYPE_UI8 The amount of memory allocated for use by the object, which may be greater than the amount of memory actually used by the object.
MemoryAllocBase DBTYPE_UI8 The bytes initially allocated for the object itself (excluding additional allocations for object contents).
MemoryAllocFromAlloc DBTYPE_UI8 The memory allocated for the contents of this object.
ElementCount DBTYPE_UI4 For a container object, this is the number of objects contained by that object.
Shrinkable DBTYPE_BOOL Yes 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 DBTYPE_WSTR A string identifying the full path of this object.
ObjectID DBTYPE_WSTR A string identifying the object. The full path of this object is represented by the string: (ObjectParentPath + '.' + ObjectId).

This schema rowset is not sorted.

Using ADOMD.NET to return the rowset

When using ADOMD.NET and the schema rowset to retrieve metadata, you can use either the GUID or string to reference a schema rowset object in the GetSchemaDataSet method. For more information, see Working with Schema Rowsets in ADOMD.NET.

The following table provides the GUID and string values that identify this rowset.

Argument Value
GUID A07CCD21-8148-11D0-87BB-00C04FC33942

See Also

XML for Analysis Schema Rowsets