Applies To: SQL Server 2016 Preview

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

System_CAPS_ICON_warning.jpg Warning

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

The DISCOVER_MEMORYUSAGE rowset contains the following columns.

Column nameType indicatorRestrictionDescription
MemoryIDDBTYPE_UI8A number identifying the memory.
MemoryNameDBTYPE_WSTRThe name of the object owning the memory.
SPIDDBTYPE_UI4YesThe session that allocated the memory. Zero indicates memory not tied to a specific session.
CreationTimeDBTYPE_DBTIMESTAMPEither "the time the object was created" or "the time the memory was allocated."
BaseObjectTypeDBTYPE_UI4YesThis is a number describing the type of the object. Objects with the same BaseObjectType have the same type.
MemoryUsedDBTYPE_UI8YesThis is the current size of the object, which may be less than the memory allocated for use by the object.
MemoryAllocatedDBTYPE_UI8The amount of memory allocated for use by the object, which may be greater than the amount of memory actually used by the object.
MemoryAllocBaseDBTYPE_UI8The bytes initially allocated for the object itself (excluding additional allocations for object contents).
MemoryAllocFromAllocDBTYPE_UI8The memory allocated for the contents of this object.
ElementCountDBTYPE_UI4For a container object, this is the number of objects contained by that object.
ShrinkableDBTYPE_BOOLYesA 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.
ObjectParentPathDBTYPE_WSTRA string identifying the full path of this object.
ObjectIDDBTYPE_WSTRA string identifying the object. The full path of this object is represented by the string: (ObjectParentPath + '.' + ObjectId).

This schema rowset is not sorted.

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.


XML for Analysis Schema Rowsets

Community Additions