Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

DISCOVER_MEMORYUSAGE Rowset

SQL Server 2012

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

Caution note Caution

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

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.

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.