SAP MSSMEMQGRANTS Table in S/4 HANA - Data from dm_exec_query_memory_grants
MSSMEMQGRANTS is a standard SAP Table which is used to store Data from dm_exec_query_memory_grants data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system
Even using an S/4 Hana system you can still view further information about the SAP MSSMEMQGRANTS table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Cannot Be Enhanced
Dictionary Type: Structure
Database Table: MSSMEMQGRANTS
MSSMEMQGRANTS table structure field list
Below is the full MSSMEMQGRANTS field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
| SESSID | Session ID for SQL Server | MSSSESSIONID | INT4 | 10(0) | MSSINT4 | |||||
| REQID | SQL Server Request ID | MSSREQUESTID | INT4 | 10(0) | ||||||
| SCHEDID | ID of the scheduler used for the request | MSSREQSCHEDULERID | INT4 | 10(0) | ||||||
| DOP | Degree of parallelism of a query | MSSDOP | INT2 | 5(0) | ||||||
| REQTIME | Request time | MSSREQTIME | DEC | 15(0) | TZNTSTMPS | |||||
| GRANTTIME | Grant time | MSSGRANTTIME | DEC | 15(0) | TZNTSTMPS | |||||
| REQMEMKB | Requested amount of memory in KB | MSSREQMEMKB | DEC | 20(0) | ||||||
| GRANTMEMKB | Granted memory in KB | MSSGRANTMEMKB | DEC | 20(0) | ||||||
| REQRMEMKB | Required memory for a query | MSSREQRMEMKB | DEC | 20(0) | ||||||
| USEDMEMKB | Used memory in KB | MSSUSEDMEMKB | DEC | 20(0) | ||||||
| MAXUSEDMEMKB | Maximum physical memory used up to this moment | MSSMAXUSEDMEMKB | DEC | 20(0) | ||||||
| QCOST | Query cost | MSSQCOST | DEC | 20(2) | ||||||
| TIMEOUTSEC | Memory grant timeout in seconds of a single request | MSSRQMEMTIMEOUT | INT4 | 10(0) | INT4 | |||||
| RESSEMID | Resource semaphore ID | MSSSEMID | INT2 | 5(0) | ||||||
| QUEUEID | Queue ID | MSSQUEUEID | INT2 | 5(0) | ||||||
| WAITORDER | Sequential order of waiting queries within queue | MSSWAITORDER | INT4 | 10(0) | ||||||
| ISNEXTCND | Set if query is a candidate for next memory grant | MSSISNEXTCND | INT1 | 3(0) | ||||||
| WAITMS | Process wait time | MSSDLWAITTM | DEC | 20(0) | ||||||
| PLANHANDLE | handle pointing to plan used in execution of sql stmt/proc | MSSPLANHANDLE | CHAR | 130(0) | MSSHANDLE | |||||
| SQLHANDLE | handle pointing to sql statment or procedure | MSSSQLHANDLE | CHAR | 130(0) | MSSHANDLE | |||||
| GRPID | Resource group ID | MSSGRPID | INT4 | 10(0) | INT4 | |||||
| POOLID | ID of a resource pool | MSSRGPOOLID | INT4 | 10(0) | INT4 | |||||
| ISSMALL | Uses small resource semaphore | MSSISSMALL | INT1 | 3(0) | ||||||
| IDEALMEMKB | Ideal memory KB | MSSIDEALMEMKB | DEC | 20(0) |
Search for further information about these or an SAP related objects