SAP ABAP Table MSS_REQUEST (sys.dm_exec_requests structure from SQL Server 9.0)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
     ⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects

Basic Data

Table Category	INTTAB	Structure
Structure	MSS_REQUEST	Table Relationship Diagram
Short Description	sys.dm_exec_requests structure from SQL Server 9.0

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	REQ_SESSIONID	☐	MSSREQSID		INT4	10	0	Session ID associated with the request being processed
2	REQUESTID	☐	MSSREQUESTID		INT4	10	0	SQL Server Request ID
3	START_TIME	☐	MSSREQDATE		CHAR	24	0	Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS
4	STATUS	☐	MSQPROSTAT	CHAR60	CHAR	60	0	SQL Server process status; ie sleeping, running etc.
5	COMMAND	☐	MSQEXECMD	CHAR32	CHAR	32	0	Command currently being executed by the given process id
6	SQLHANDLE	☐	MSSSQLHANDLE	MSSHANDLE	CHAR	130	0	handle pointing to sql statment or procedure
7	STMT_START_OFFSET	☐	MSSINT4		INT4	10	0	SQL Server int4
8	STMT_END_OFFSET	☐	MSSINT4		INT4	10	0	SQL Server int4
9	PLAN_HANDLE	☐	MSSPLANHANDLE	MSSHANDLE	CHAR	130	0	handle pointing to plan used in execution of sql stmt/proc
10	DBNAME	☐	MSSDB	MSSSYSNAME	CHAR	128	0	Database name
11	USERNAME	☐	MSQUSRNAME	CHAR128	CHAR	128	0	The user name used to log into the SQL Server database
12	REQ_CONNECTIONID	☐	MSSREQCONNID	MSSUNIQIDENT	CHAR	36	0	SQL Server connection id
13	BLOCKING_SESSION_ID	☐	MSSBLKSESSIONID		INT4	10	0	Blocking session ID for SQL Server
14	WAIT_TIME	☐	MSQWAITIME	INT4	INT4	10	0	Current wait time of the process in milliseconds
15	LAST_WAIT_TYPE	☐	MSQSQLWAIT	CHAR64	CHAR	64	0	The locked resource process is waiting for (object ID).
16	WAIT_RESOURCE	☐	MSQSAPWAIT	CHAR255	CHAR	255	0	Name of the locked resource the process is waiting for.
17	OPEN_TRAN_CNT	☐	MSSOPENTRAN		INT4	10	0	Number of open transactions for the SQL Server process
18	OPEN_RESULTSET_CNT	☐	MSSOPENRES		INT4	10	0	Number of open result sets for the SQL Server process
19	TRANSACTION_ID	☐	MSSTRANSACTIONID	MSQBIGINT	DEC	20	0	Transaction identifier request executes under
20	PERCENT_COMPLETE	☐	MSSPRCCOMP		DEC	6	2	Percentage complete
21	EST_COMPLETION_TIME	☐	MSSESTCMPTIME	MSQBIGINT	DEC	20	0	Estimated Completion time of SQL Request
22	REQ_CPUTIME	☐	MSSREQCPUTIME	INT4	INT4	10	0	CPU time for a request
23	REQ_TTLTIME	☐	MSSREQTTL		INT4	10	0	Total elapsed time utilized by a request
24	SCHED_ID	☐	MSSREQSCHEDULERID		INT4	10	0	ID of the scheduler used for the request
25	REQ_NUMREADS	☐	MSSREQNUMREADS	MSQBIGINT	DEC	20	0	number of reads performed by the request
26	REQ_NUMWRITES	☐	MSSREQNUMWRITES	MSQBIGINT	DEC	20	0	number of writes performed in a request
27	REQ_NUMLOGICALREADS	☐	MSSREQNUMLOGRDS	MSQBIGINT	DEC	20	0	number of reads performed by a request
28	REQ_ROWCOUNT	☐	MSSROWCOUNT	MSQBIGINT	DEC	20	0	SQL Server count of rows returned
29	SQLTEXT	☐	MSSPARTIALSQL	TEXT50	CHAR	50	0	First 50 characters of a SQL Server statement

History

Last changed by/on	SAP	20130604
SAP Release Created in	700