SAP ABAP Table MSS_ACTIVE_REQUEST (Active SQL Server requests with their connections & sessions)

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_ACTIVE_REQUEST	Table Relationship Diagram
Short Description	Active SQL Server requests with their connections & sessions

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	.INCLUDE	☐				0	0	/sys.dm_exec_sessions structure from SQL Server 9.0
2	SESSIONID	☐	MSSSESSIONID	MSSINT4	INT4	10	0	Session ID for SQL Server
3	LOGINTIME	☐	MSQPRLGTME	CHAR24	CHAR	24	0	The time at which client process logged into SQL Server.
4	HOSTNAME	☐	MSQHOSTNE	CHAR128	CHAR	128	0	Hostname of the application server logged into SQL Server.
5	PROGNAME	☐	MSQAPPPROG	CHAR256	CHAR	256	0	Name of the application program which owns the connection.
6	HOSTPID	☐	MSSHPID	MSSINT4	INT4	10	0	Process ID on app. server
7	CLIENTINFVER	☐	MSSSESSINTFVER		INT4	10	0	MSS Session client interface name
8	CLIENTINFNAME	☐	MSSSESSINTFNAME	CHAR64	CHAR	64	0	MSS Session client interface name
9	LOGINNAME	☐	MSQUSRNAME	CHAR128	CHAR	128	0	The user name used to log into the SQL Server database
10	NTDOMAIN	☐	MSQNTDOMA	CHAR256	CHAR	256	0	NT domain for the client connected to SQL Server.
11	NTUNAME	☐	MSQNTUNAME	CHAR256	CHAR	256	0	Windows NT user name for the process connected to SQL Server
12	CPUTIME	☐	MSSSESCPUTIME	INT4	INT4	10	0	CPU time for a SQL session (ms)
13	MEMUSAGE	☐	MSQPRMEMUS	INT4	INT4	10	0	The pages allocated by the SQL process in procedure cache.
14	TTLSCHEDTIME	☐	MSSESSCHTIME		INT4	10	0	SQL Server session scheduled time
15	TTLELAPSEDTIME	☐	MSSESSELPTIME		INT4	10	0	SQL Server session elapsed time
16	SESS_NUMREADS	☐	MSSSESNUMREADS	MSQBIGINT	DEC	20	0	number of reads performed in a session
17	SESS_NUMWRITES	☐	MSSSESNUMWRITES	MSQBIGINT	DEC	20	0	Number of writes performed in a session
18	SESS_NUMLOGICALREADS	☐	MSSSESNUMLOGRDS	MSQBIGINT	DEC	20	0	number of reads performed by a session
19	TRXISOLEVEL	☐	MSSTRXISOLEVEL		CHAR	12	0	MSS Transaction Isolation level
20	.INCLUDE	☐				0	0	sys.dm_exec_connections structure from SQL Server 9.0
21	CONNECTIONID	☐	MSSCONNECTIONID	MSSUNIQIDENT	CHAR	36	0	SQL Server connection id
22	PARENT_CONNID	☐	MSSPARENTCONNID	MSSUNIQIDENT	CHAR	36	0	SQL Server parent connection id
23	CONN_SESSIONID	☐	MSSCONNSID		INT4	10	0	Session ID running on connection
24	CONNECT_TIME	☐	MSSCONNDATE		CHAR	24	0	Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS
25	NET_TRANSPORT	☐	MSSNETRANSPORT	CHAR80	CHAR	80	0	The network transport type used by the connection
26	PROTOCOL_TYPE	☐	MSSPROTYPE	CHAR80	CHAR	80	0	The network transport protocol used by the connection
27	CONN_NUMREADS	☐	MSSCONNUMREADS		INT4	10	0	SQL Server connection number of reads over the connection
28	CONN_NUMWRITES	☐	MSSCONNUMWRITES		INT4	10	0	SQL Server conneciton number of writes over the connection
29	LAST_READ	☐	MSSCONNLASTRD		CHAR	24	0	Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS
30	LAST_WRITE	☐	MSSCONNLASTWT		CHAR	24	0	Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS
31	NET_PACKET_SIZE	☐	MSSPACKSZ		INT4	10	0	SQL Server packet size
32	CLIENT_NET_ADDR	☐	MSSCONNETADDR	CHAR40	CHAR	40	0	Connection network address
33	.INCLUDE	☐				0	0	sys.dm_exec_requests structure from SQL Server 9.0
34	REQ_SESSIONID	☐	MSSREQSID		INT4	10	0	Session ID associated with the request being processed
35	REQUESTID	☐	MSSREQUESTID		INT4	10	0	SQL Server Request ID
36	START_TIME	☐	MSSREQDATE		CHAR	24	0	Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS
37	STATUS	☐	MSQPROSTAT	CHAR60	CHAR	60	0	SQL Server process status; ie sleeping, running etc.
38	COMMAND	☐	MSQEXECMD	CHAR32	CHAR	32	0	Command currently being executed by the given process id
39	SQLHANDLE	☐	MSSSQLHANDLE	MSSHANDLE	CHAR	130	0	handle pointing to sql statment or procedure
40	STMT_START_OFFSET	☐	MSSINT4		INT4	10	0	SQL Server int4
41	STMT_END_OFFSET	☐	MSSINT4		INT4	10	0	SQL Server int4
42	PLAN_HANDLE	☐	MSSPLANHANDLE	MSSHANDLE	CHAR	130	0	handle pointing to plan used in execution of sql stmt/proc
43	DBNAME	☐	MSSDB	MSSSYSNAME	CHAR	128	0	Database name
44	USERNAME	☐	MSQUSRNAME	CHAR128	CHAR	128	0	The user name used to log into the SQL Server database
45	REQ_CONNECTIONID	☐	MSSREQCONNID	MSSUNIQIDENT	CHAR	36	0	SQL Server connection id
46	BLOCKING_SESSION_ID	☐	MSSBLKSESSIONID		INT4	10	0	Blocking session ID for SQL Server
47	WAIT_TIME	☐	MSQWAITIME	INT4	INT4	10	0	Current wait time of the process in milliseconds
48	LAST_WAIT_TYPE	☐	MSQSQLWAIT	CHAR64	CHAR	64	0	The locked resource process is waiting for (object ID).
49	WAIT_RESOURCE	☐	MSQSAPWAIT	CHAR255	CHAR	255	0	Name of the locked resource the process is waiting for.
50	OPEN_TRAN_CNT	☐	MSSOPENTRAN		INT4	10	0	Number of open transactions for the SQL Server process
51	OPEN_RESULTSET_CNT	☐	MSSOPENRES		INT4	10	0	Number of open result sets for the SQL Server process
52	TRANSACTION_ID	☐	MSSTRANSACTIONID	MSQBIGINT	DEC	20	0	Transaction identifier request executes under
53	PERCENT_COMPLETE	☐	MSSPRCCOMP		DEC	6	2	Percentage complete
54	EST_COMPLETION_TIME	☐	MSSESTCMPTIME	MSQBIGINT	DEC	20	0	Estimated Completion time of SQL Request
55	REQ_CPUTIME	☐	MSSREQCPUTIME	INT4	INT4	10	0	CPU time for a request
56	REQ_TTLTIME	☐	MSSREQTTL		INT4	10	0	Total elapsed time utilized by a request
57	SCHED_ID	☐	MSSREQSCHEDULERID		INT4	10	0	ID of the scheduler used for the request
58	REQ_NUMREADS	☐	MSSREQNUMREADS	MSQBIGINT	DEC	20	0	number of reads performed by the request
59	REQ_NUMWRITES	☐	MSSREQNUMWRITES	MSQBIGINT	DEC	20	0	number of writes performed in a request
60	REQ_NUMLOGICALREADS	☐	MSSREQNUMLOGRDS	MSQBIGINT	DEC	20	0	number of reads performed by a request
61	REQ_ROWCOUNT	☐	MSSROWCOUNT	MSQBIGINT	DEC	20	0	SQL Server count of rows returned
62	SQLTEXT	☐	MSSPARTIALSQL	TEXT50	CHAR	50	0	First 50 characters of a SQL Server statement
63	OBJECT_NAME	☐	MSSOBJNAME	TEXT30	CHAR	30	0	MS SQL Server object name
64	ABAP_NAME	☐	MSSABNAME	PROGNAME	CHAR	40	0	Name of the ABAP report
65	ABAP_LOC	☐	ABP_CONT		INT4	10	0	Offset of a Processing Control Block
66	SAP_USER	☐	MSSSAPUSER		CHAR	12	0	The user name in the SAP system.
67	CPU_TTL	☐	MSSCPUTIME	INT4	INT4	10	0	MS SQL Server cumulative cpu time
68	READS_TTL	☐	MSSNUMREADS	MSQBIGINT	DEC	20	0	Total number of reads performed by a session and request
69	WRTS_TTL	☐	MSSNUMWRITES	MSQBIGINT	DEC	20	0	Total number of writes performed
70	LOGRDS_TTL	☐	MSSNUMLOGREADS	MSQBIGINT	DEC	20	0	Total number of reads performed
71	WPNAME	☐	MSSWPNAME	CHAR3	CHAR	3	0	ID of the R3 work process

History

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