SAP ABAP Table MSQPROCESS (MS SQL server processes ( as from sysprocesses ))
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 MSQPROCESS   Table Relationship Diagram
Short Description MS SQL server processes ( as from sysprocesses )    
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 MSQSYPROID INT2 INT2 5   0   MS SQL Server process ID  
2 KPID MSQTHREDID INT2 INT2 5   0   Windows operating system thread ID  
3 BLOCKED MSQBLOPRID INT2 INT2 5   0   SPID of blocking process.  
4 WAITTYPE MSQWAITTYP INT2 INT2 5   0   Wait type of waiting process, reserved field of sysprocesses  
5 DBID MSQDBASEID INT2 INT2 5   0   MS SQL Server database ID  
6 USERID MSQUID INT2 INT2 5   0   MS SQL Server - user identification ID  
7 CPUTIME MSQCPUTIME INT4 INT4 10   0   MS SQL Server total cumulative CPU time for a SQL process  
8 PHYIO MSQPHYSIIO MSQBIGINT DEC 20   0   The total cumulative disk reads and writes for the process.  
9 MEMUSUAGE MSQPRMEMUS INT4 INT4 10   0   The pages allocated by the SQL process in procedure cache.  
10 LOGINTIME MSQLOGTIME CHAR24 CHAR 24   0   Login Time for client process or system startup time  
11 LSTBATTIME MSQLSTEXST CHAR24 CHAR 24   0   Last time exec. of remote stored proc. call or sql stat.  
12 PROSTATUS MSQPROSTAT CHAR60 CHAR 60   0   SQL Server process status; ie sleeping, running etc.  
13 SIDNAME MSQUSRNAME CHAR128 CHAR 128   0   The user name used to log into the SQL Server database  
14 HOSTNAME MSQHOSTNAM CHAR256 CHAR 256   0   Hostname of the application server logged into SQL Server.  
15 PRONAME MSQAPPPROG CHAR256 CHAR 256   0   Name of the application program which owns the connection.  
16 HOSTPRO MSQWKPROID CHAR16 CHAR 16   0   The application program's process ID on the given host  
17 CMD MSQEXECMD CHAR32 CHAR 32   0   Command currently being executed by the given process id  
18 NTDOMAIN MSQNTDOMA CHAR256 CHAR 256   0   NT domain for the client connected to SQL Server.  
19 NTUNAME MSQNTUNAME CHAR256 CHAR 256   0   Windows NT user name for the process connected to SQL Server  
20 NETADD MSQNETADDR CHAR12 CHAR 12   0   Unique ID of the network interface of client (MAC address).  
21 NETLIB MSQNETLIB CHAR12 CHAR 12   0   The network library the client is using.  
22 SUIDNAME MSQUSRNAME CHAR128 CHAR 128   0   The user name used to log into the SQL Server database  
History
Last changed by/on SAP  20130604 
SAP Release Created in