DISCOVER_MEMORYUSAGE Rowset
Returns the DISCOVER_MEMORYUSAGE statistics for various objects allocated by the server.
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:
'<drive>:\Users\<username>\AppData\Local\Temp\<fileID>.xml'.
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 |
ADOMDNAME |
MemoryUsage |