SAP ABAP Table MSQ_PROCES (Data on the processes connected SQL Server)

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	MSQ_PROCES	Table Relationship Diagram
Short Description	Data on the processes connected SQL Server

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

History

Last changed by/on	SAP	20110908
SAP Release Created in