Data Element list used by SAP ABAP Table MSQPROCESS (MS SQL server processes ( as from sysprocesses ))
SAP ABAP Table 
MSQPROCESS (MS SQL server processes ( as from sysprocesses )) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Data Element |
MSQAPPPROG | Name of the application program which owns the connection. | |
| 2 | Data Element |
MSQBLOPRID | SPID of blocking process. | |
| 3 | Data Element |
MSQCPUTIME | MS SQL Server total cumulative CPU time for a SQL process | |
| 4 | Data Element |
MSQDBASEID | MS SQL Server database ID | |
| 5 | Data Element |
MSQEXECMD | Command currently being executed by the given process id | |
| 6 | Data Element |
MSQHOSTNAM | Hostname of the application server logged into SQL Server. | |
| 7 | Data Element |
MSQLOGTIME | Login Time for client process or system startup time | |
| 8 | Data Element |
MSQLSTEXST | Last time exec. of remote stored proc. call or sql stat. | |
| 9 | Data Element |
MSQNETADDR | Unique ID of the network interface of client (MAC address). | |
| 10 | Data Element |
MSQNETLIB | The network library the client is using. | |
| 11 | Data Element |
MSQNTDOMA | NT domain for the client connected to SQL Server. | |
| 12 | Data Element |
MSQNTUNAME | Windows NT user name for the process connected to SQL Server | |
| 13 | Data Element |
MSQPHYSIIO | The total cumulative disk reads and writes for the process. | |
| 14 | Data Element |
MSQPRMEMUS | The pages allocated by the SQL process in procedure cache. | |
| 15 | Data Element |
MSQPROSTAT | SQL Server process status; ie sleeping, running etc. | |
| 16 | Data Element |
MSQSYPROID | MS SQL Server process ID | |
| 17 | Data Element |
MSQTHREDID | Windows operating system thread ID | |
| 18 | Data Element |
MSQUID | MS SQL Server - user identification ID | |
| 19 | Data Element |
MSQUSRNAME | The user name used to log into the SQL Server database | |
| 20 | Data Element |
MSQUSRNAME | The user name used to log into the SQL Server database | |
| 21 | Data Element |
MSQWAITTYP | Wait type of waiting process, reserved field of sysprocesses | |
| 22 | Data Element |
MSQWKPROID | The application program's process ID on the given host |
