DISCOVER_MEMORYGRANT Rowset

Returns a list of internal memory quota grants that are taken by jobs that are currently running on the server. To find out whether a job is running on the server, use Select * from $System.Discover_Jobs.

Applies to: tabular models, multidimensional models

Rowset Columns

The DISCOVER_MEMORYGRANT rowset contains the following columns.

Column name

Type indicator

Restriction

Description

MEMORY_ID

DBTYPE_I8

 

A number that identifies the memory quota grant. Unique within the context of a single DISCOVER_MEMORYGRANT request.

SPID

DBTYPE_I4

Required 

The SPID, which you can obtain by running Select * from $System.Discover_Sessions.

CreationTime

DBTYPE_I8 DBTYPE_DBTIMESTAMP

 

The time the quota was granted.

LastRequestTime

DBTYPE_DBTIMESTAMP

 

The time the quota request was last modified.

MemoryUsed

DBTYPE_I4

 

The amount of memory used in association with the quota.

MemoryGranted

DBTYPE_I4

 

The amount of memory granted for use by the job that is obtaining the memory quota.

Blocked

DBTYPE_BOOL

 

A Boolean that indicates the block status of the job. True indicates that the job is blocked waiting for another job to release sufficient quota to grant its quota request. False indicates that the job has received its quota and can execute.

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

a07ccd23-8148-11d0-87bb-00c04fc33942

ADOMDNAME

MemoryGrant

See Also

Reference

XML for Analysis Schema Rowsets