Applies To: SQL Server 2016 Preview

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

The DISCOVER_MEMORYGRANT rowset contains the following columns.

Column nameType indicatorRestrictionDescription
MEMORY_IDDBTYPE_I8A number that identifies the memory quota grant. Unique within the context of a single DISCOVER_MEMORYGRANT request.
SPIDDBTYPE_I4RequiredThe SPID, which you can obtain by running Select * from $System.Discover_Sessions.
CreationTimeDBTYPE_I8 DBTYPE_DBTIMESTAMPThe time the quota was granted.
LastRequestTimeDBTYPE_DBTIMESTAMPThe time the quota request was last modified.
MemoryUsedDBTYPE_I4The amount of memory used in association with the quota.
MemoryGrantedDBTYPE_I4The amount of memory granted for use by the job that is obtaining the memory quota.
BlockedDBTYPE_BOOLA 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.

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