SAP MSSMEMQGRANTS table - Data from dm_exec_query_memory_grants details in SAP

SAP MSSMEMQGRANTS table summary

Object Name: MSSMEMQGRANTS
Dictionary Type: Structure
Description: Data from dm_exec_query_memory_grants

Field list for MSSMEMQGRANTS table on an S/4 SAP system

Details

MSSMEMQGRANTS-SESSID table field - Session ID for SQL Server ▼

Description: Session ID for SQL Server
Field Name: SESSID
Data Element: MSSSESSIONID
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: MSSINT4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SESSID

MSSMEMQGRANTS-REQID table field - SQL Server Request ID ▼

Description: SQL Server Request ID
Field Name: REQID
Data Element: MSSREQUESTID
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REQID

MSSMEMQGRANTS-SCHEDID table field - ID of the scheduler used for the request ▼

Description: ID of the scheduler used for the request
Field Name: SCHEDID
Data Element: MSSREQSCHEDULERID
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SCHEDID

MSSMEMQGRANTS-DOP table field - Degree of parallelism of a query ▼

Description: Degree of parallelism of a query
Field Name: DOP
Data Element: MSSDOP
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DOP

MSSMEMQGRANTS-REQTIME table field - Request time ▼

Description: Request time
Field Name: REQTIME
Data Element: MSSREQTIME
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: TZNTSTMPS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REQTIME

MSSMEMQGRANTS-GRANTTIME table field - Grant time ▼

Description: Grant time
Field Name: GRANTTIME
Data Element: MSSGRANTTIME
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: TZNTSTMPS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field GRANTTIME

MSSMEMQGRANTS-REQMEMKB table field - Requested amount of memory in KB ▼

Description: Requested amount of memory in KB
Field Name: REQMEMKB
Data Element: MSSREQMEMKB
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REQMEMKB

MSSMEMQGRANTS-GRANTMEMKB table field - Granted memory in KB ▼

Description: Granted memory in KB
Field Name: GRANTMEMKB
Data Element: MSSGRANTMEMKB
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field GRANTMEMKB

MSSMEMQGRANTS-REQRMEMKB table field - Required memory for a query ▼

Description: Required memory for a query
Field Name: REQRMEMKB
Data Element: MSSREQRMEMKB
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REQRMEMKB

MSSMEMQGRANTS-USEDMEMKB table field - Used memory in KB ▼

Description: Used memory in KB
Field Name: USEDMEMKB
Data Element: MSSUSEDMEMKB
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USEDMEMKB

MSSMEMQGRANTS-MAXUSEDMEMKB table field - Maximum physical memory used up to this moment ▼

Description: Maximum physical memory used up to this moment
Field Name: MAXUSEDMEMKB
Data Element: MSSMAXUSEDMEMKB
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAXUSEDMEMKB

MSSMEMQGRANTS-QCOST table field - Query cost ▼

Description: Query cost
Field Name: QCOST
Data Element: MSSQCOST
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QCOST

MSSMEMQGRANTS-TIMEOUTSEC table field - Memory grant timeout in seconds of a single request ▼

Description: Memory grant timeout in seconds of a single request
Field Name: TIMEOUTSEC
Data Element: MSSRQMEMTIMEOUT
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TIMEOUTSEC

MSSMEMQGRANTS-RESSEMID table field - Resource semaphore ID ▼

Description: Resource semaphore ID
Field Name: RESSEMID
Data Element: MSSSEMID
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RESSEMID

MSSMEMQGRANTS-QUEUEID table field - Queue ID ▼

Description: Queue ID
Field Name: QUEUEID
Data Element: MSSQUEUEID
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QUEUEID

MSSMEMQGRANTS-WAITORDER table field - Sequential order of waiting queries within queue for Memory ▼

Description: Sequential order of waiting queries within queue for Memory
Field Name: WAITORDER
Data Element: MSSWAITORDER
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAITORDER

MSSMEMQGRANTS-ISNEXTCND table field - Set if query is a candidate for next memory grant ▼

Description: Set if query is a candidate for next memory grant
Field Name: ISNEXTCND
Data Element: MSSISNEXTCND
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ISNEXTCND

MSSMEMQGRANTS-WAITMS table field - Process wait time ▼

Description: Process wait time
Field Name: WAITMS
Data Element: MSSDLWAITTM
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAITMS

MSSMEMQGRANTS-PLANHANDLE table field - handle pointing to plan used in execution of sql stmt/proc ▼

Description: handle pointing to plan used in execution of sql stmt/proc
Field Name: PLANHANDLE
Data Element: MSSPLANHANDLE
Data Type: CHAR
length (Dec): 130(0)
Check table:
Conversion Routine:
Domain Name: MSSHANDLE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PLANHANDLE

MSSMEMQGRANTS-SQLHANDLE table field - handle pointing to sql statment or procedure ▼

Description: handle pointing to sql statment or procedure
Field Name: SQLHANDLE
Data Element: MSSSQLHANDLE
Data Type: CHAR
length (Dec): 130(0)
Check table:
Conversion Routine:
Domain Name: MSSHANDLE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLHANDLE

MSSMEMQGRANTS-GRPID table field - Resource group ID ▼

Description: Resource group ID
Field Name: GRPID
Data Element: MSSGRPID
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field GRPID

MSSMEMQGRANTS-POOLID table field - ID of a resource pool ▼

Description: ID of a resource pool
Field Name: POOLID
Data Element: MSSRGPOOLID
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POOLID

MSSMEMQGRANTS-ISSMALL table field - Uses small resource semaphore ▼

Description: Uses small resource semaphore
Field Name: ISSMALL
Data Element: MSSISSMALL
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ISSMALL

MSSMEMQGRANTS-IDEALMEMKB table field - Ideal memory KB ▼

Description: Ideal memory KB
Field Name: IDEALMEMKB
Data Element: MSSIDEALMEMKB
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IDEALMEMKB

View list of all SAP tables(S4H/ECC)

Select data from SAP table