SAP ABAP Table MSQPROCINF (MS SQL server - processes informations)
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 MSQPROCINF   Table Relationship Diagram
Short Description MS SQL server - processes informations    
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 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 DBNAME MSQDBNAME CHAR255 CHAR 255   0   The name of the database in SQL Server instance.  
6 UIDNAME MSQUID INT2 INT2 5   0   MS SQL Server - user identification ID  
7 CPU MSQCPUTIME INT4 INT4 10   0   MS SQL Server total cumulative CPU time for a SQL process  
8 PHYSIO MSQPHYSIIO MSQBIGINT DEC 20   0   The total cumulative disk reads and writes for the process.  
9 MEMUSAGE MSQPRMEMUS INT4 INT4 10   0   The pages allocated by the SQL process in procedure cache.  
10 LOGINTIME MSQPRLGTME CHAR24 CHAR 24   0   The time at which client process logged into SQL Server.  
11 LSTBATTIME MSQLTBATTM CHAR24 CHAR 24   0   Last time a stor. proc. or EXEC was executed on SQL process.  
12 STATUS MSQPROSTAT CHAR60 CHAR 60   0   SQL Server process status; ie sleeping, running etc.  
13 LOGINNAME 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 PROGNAME MSQAPPPROG CHAR256 CHAR 256   0   Name of the application program which owns the connection.  
16 HOSTPROS MSQWKPROID CHAR16 CHAR 16   0   The application program's process ID on the given host  
17 EXECCMD 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