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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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