SAP ABAP Table MSSPRCINF7 (MS SQL Server: Process Monitor)

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	MSSPRCINF7	Table Relationship Diagram
Short Description	MS SQL Server: Process Monitor

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	Data on the processes connected SQL Server
2	SPID	☐	MSQSERPRID	INT4	INT4	10	0	SQL Server process ID
3	KPID	☐	MSQTHREADI	INT4	INT4	10	0	Windows operating system thread ID of SQL process
4	BLOCKED	☐	MSQBLOCPRI	INT4	INT4	10	0	The SPID of the process blocking this SQL process.
5	WAITTYPE	☐	MSQWAITYPE	INT4	INT4	10	0	The wait type of the waiting process.
6	WAITTIME	☐	MSQWAITIME	INT4	INT4	10	0	Current wait time of the process in milliseconds
7	SQLWAITRES	☐	MSQWAITRES	CHAR32	CHAR	32	0	The last wait event the process had to wait for..
8	SAPWAIT	☐	MSQSAPWAIT	CHAR255	CHAR	255	0	Name of the locked resource the process is waiting for.
9	SQLWAIT	☐	MSQSQLWAIT	CHAR64	CHAR	64	0	The locked resource process is waiting for (object ID).
10	DBNAME	☐	MSSDB	MSSSYSNAME	CHAR	128	0	Database name
11	CPU	☐	MSQCPUTIME	INT4	INT4	10	0	MS SQL Server total cumulative CPU time for a SQL process
12	PHYSIO	☐	MSQPHYSIIO	MSQBIGINT	DEC	20	0	The total cumulative disk reads and writes for the process.
13	MEMUSAGE	☐	MSQPRMEMUS	INT4	INT4	10	0	The pages allocated by the SQL process in procedure cache.
14	LOGINTIME	☐	MSQPRLGTME	CHAR24	CHAR	24	0	The time at which client process logged into SQL Server.
15	LSTBATTIME	☐	MSQLTBATTM	CHAR24	CHAR	24	0	Last time a stor. proc. or EXEC was executed on SQL process.
16	ECID	☐	MSQPRCECID	INT4	INT4	10	0	Execution context ID used to uniquely identify subthreads
17	OPENTRAN	☐	MSSOPENTRAN		INT4	10	0	Number of open transactions for the SQL Server process
18	STATUS	☐	MSQPROSTAT	CHAR60	CHAR	60	0	SQL Server process status; ie sleeping, running etc.
19	LOGINNAME	☐	MSQUSRNAME	CHAR128	CHAR	128	0	The user name used to log into the SQL Server database
20	HOSTNAME	☐	MSQHOSTNE	CHAR128	CHAR	128	0	Hostname of the application server logged into SQL Server.
21	PROGNAME	☐	MSQAPPPROG	CHAR256	CHAR	256	0	Name of the application program which owns the connection.
22	HOSTPROS	☐	MSQWKPROID	CHAR16	CHAR	16	0	The application program's process ID on the given host
23	EXECCMD	☐	MSQEXECMD	CHAR32	CHAR	32	0	Command currently being executed by the given process id
24	NTDOMAIN	☐	MSQNTDOMA	CHAR256	CHAR	256	0	NT domain for the client connected to SQL Server.
25	NTUNAME	☐	MSQNTUNAME	CHAR256	CHAR	256	0	Windows NT user name for the process connected to SQL Server
26	NETADD	☐	MSQNETADDR	CHAR12	CHAR	12	0	Unique ID of the network interface of client (MAC address).
27	NETLIB	☐	MSQNETLIB	CHAR12	CHAR	12	0	The network library the client is using.
28	SAPUSER	☐	MSSSAPUSER		CHAR	12	0	The user name in the SAP system.
29	REPORTNAME	☐	WPREPORT	WPREPORT	CHAR	40	0	Report now running

History

Last changed by/on	SAP	20130604
SAP Release Created in