SAP MSS_REQUEST table - sys.dm_exec_requests structure from SQL Server 9.0 details in SAP


SAP MSS_REQUEST table summary

Object Name: MSS_REQUEST
Dictionary Type: Structure
Description: sys.dm_exec_requests structure from SQL Server 9.0


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

Details
MSS_REQUEST-REQ_SESSIONID table field - Session ID associated with the request being processed

Description: Session ID associated with the request being processed
Field Name: REQ_SESSIONID
Data Element: MSSREQSID
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REQ_SESSIONID

MSS_REQUEST-REQUESTID table field - SQL Server Request ID

Description: SQL Server Request ID
Field Name: REQUESTID
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 REQUESTID

MSS_REQUEST-START_TIME table field - Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS

Description: Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS
Field Name: START_TIME
Data Element: MSSREQDATE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field START_TIME

MSS_REQUEST-STATUS table field - SQL Server process status; ie sleeping, running etc.

Description: SQL Server process status; ie sleeping, running etc.
Field Name: STATUS
Data Element: MSQPROSTAT
Data Type: CHAR
length (Dec): 60(0)
Check table:
Conversion Routine:
Domain Name: CHAR60
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STATUS

MSS_REQUEST-COMMAND table field - Command currently being executed by the given process id

Description: Command currently being executed by the given process id
Field Name: COMMAND
Data Element: MSQEXECMD
Data Type: CHAR
length (Dec): 32(0)
Check table:
Conversion Routine:
Domain Name: CHAR32
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COMMAND

MSS_REQUEST-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

MSS_REQUEST-STMT_START_OFFSET table field - SQL Server int4

Description: SQL Server int4
Field Name: STMT_START_OFFSET
Data Element: MSSINT4
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STMT_START_OFFSET

MSS_REQUEST-STMT_END_OFFSET table field - SQL Server int4

Description: SQL Server int4
Field Name: STMT_END_OFFSET
Data Element: MSSINT4
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STMT_END_OFFSET

MSS_REQUEST-PLAN_HANDLE 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: PLAN_HANDLE
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 PLAN_HANDLE

MSS_REQUEST-DBNAME table field - Database name

Description: Database name
Field Name: DBNAME
Data Element: MSSDB
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: MSSSYSNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBNAME

MSS_REQUEST-USERNAME table field - The user name used to log into the SQL Server database

Description: The user name used to log into the SQL Server database
Field Name: USERNAME
Data Element: MSQUSRNAME
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: CHAR128
MemoryID:
AppClass: SPO
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USERNAME

MSS_REQUEST-REQ_CONNECTIONID table field - SQL Server connection id

Description: SQL Server connection id
Field Name: REQ_CONNECTIONID
Data Element: MSSREQCONNID
Data Type: CHAR
length (Dec): 36(0)
Check table:
Conversion Routine:
Domain Name: MSSUNIQIDENT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REQ_CONNECTIONID

MSS_REQUEST-BLOCKING_SESSION_ID table field - Blocking session ID for SQL Server

Description: Blocking session ID for SQL Server
Field Name: BLOCKING_SESSION_ID
Data Element: MSSBLKSESSIONID
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BLOCKING_SESSION_ID

MSS_REQUEST-WAIT_TIME table field - Current wait time of the process in milliseconds

Description: Current wait time of the process in milliseconds
Field Name: WAIT_TIME
Data Element: MSQWAITIME
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 WAIT_TIME

MSS_REQUEST-LAST_WAIT_TYPE table field - The locked resource process is waiting for (object ID).

Description: The locked resource process is waiting for (object ID).
Field Name: LAST_WAIT_TYPE
Data Element: MSQSQLWAIT
Data Type: CHAR
length (Dec): 64(0)
Check table:
Conversion Routine:
Domain Name: CHAR64
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_WAIT_TYPE

MSS_REQUEST-WAIT_RESOURCE table field - Name of the locked resource the process is waiting for.

Description: Name of the locked resource the process is waiting for.
Field Name: WAIT_RESOURCE
Data Element: MSQSAPWAIT
Data Type: CHAR
length (Dec): 255(0)
Check table:
Conversion Routine:
Domain Name: CHAR255
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAIT_RESOURCE

MSS_REQUEST-OPEN_TRAN_CNT table field - Number of open transactions for the SQL Server process

Description: Number of open transactions for the SQL Server process
Field Name: OPEN_TRAN_CNT
Data Element: MSSOPENTRAN
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OPEN_TRAN_CNT

MSS_REQUEST-OPEN_RESULTSET_CNT table field - Number of open result sets for the SQL Server process

Description: Number of open result sets for the SQL Server process
Field Name: OPEN_RESULTSET_CNT
Data Element: MSSOPENRES
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OPEN_RESULTSET_CNT

MSS_REQUEST-TRANSACTION_ID table field - Transaction identifier request executes under

Description: Transaction identifier request executes under
Field Name: TRANSACTION_ID
Data Element: MSSTRANSACTIONID
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: MSQBIGINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRANSACTION_ID

MSS_REQUEST-PERCENT_COMPLETE table field - Percentage complete

Description: Percentage complete
Field Name: PERCENT_COMPLETE
Data Element: MSSPRCCOMP
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PERCENT_COMPLETE

MSS_REQUEST-EST_COMPLETION_TIME table field - Estimated Completion time of SQL Request

Description: Estimated Completion time of SQL Request
Field Name: EST_COMPLETION_TIME
Data Element: MSSESTCMPTIME
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: MSQBIGINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EST_COMPLETION_TIME

MSS_REQUEST-REQ_CPUTIME table field - CPU time for a request

Description: CPU time for a request
Field Name: REQ_CPUTIME
Data Element: MSSREQCPUTIME
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 REQ_CPUTIME

MSS_REQUEST-REQ_TTLTIME table field - Total elapsed time utilized by a request

Description: Total elapsed time utilized by a request
Field Name: REQ_TTLTIME
Data Element: MSSREQTTL
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REQ_TTLTIME

MSS_REQUEST-SCHED_ID table field - ID of the scheduler used for the request

Description: ID of the scheduler used for the request
Field Name: SCHED_ID
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 SCHED_ID

MSS_REQUEST-REQ_NUMREADS table field - number of reads performed by the request

Description: number of reads performed by the request
Field Name: REQ_NUMREADS
Data Element: MSSREQNUMREADS
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: MSQBIGINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REQ_NUMREADS

MSS_REQUEST-REQ_NUMWRITES table field - number of writes performed in a request

Description: number of writes performed in a request
Field Name: REQ_NUMWRITES
Data Element: MSSREQNUMWRITES
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: MSQBIGINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REQ_NUMWRITES

MSS_REQUEST-REQ_NUMLOGICALREADS table field - number of reads performed by a request

Description: number of reads performed by a request
Field Name: REQ_NUMLOGICALREADS
Data Element: MSSREQNUMLOGRDS
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: MSQBIGINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REQ_NUMLOGICALREADS

MSS_REQUEST-REQ_ROWCOUNT table field - SQL Server count of rows returned

Description: SQL Server count of rows returned
Field Name: REQ_ROWCOUNT
Data Element: MSSROWCOUNT
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: MSQBIGINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REQ_ROWCOUNT

MSS_REQUEST-DOP table field - DOP shown in sys.dm_exec_requests

Description: DOP shown in sys.dm_exec_requests
Field Name: DOP
Data Element: MSSREQDOP
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

MSS_REQUEST-PAR_WORKER_CNT table field - Parallel worker count from sys.dm_exec_requests

Description: Parallel worker count from sys.dm_exec_requests
Field Name: PAR_WORKER_CNT
Data Element: MSSPARWORKCNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAR_WORKER_CNT

MSS_REQUEST-SQLTEXT table field - First 50 characters of a SQL Server statement

Description: First 50 characters of a SQL Server statement
Field Name: SQLTEXT
Data Element: MSSPARTIALSQL
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLTEXT


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table