Data Element list used by SAP ABAP Table MSQ_PROCES (Data on the processes connected SQL Server)
SAP ABAP Table MSQ_PROCES (Data on the processes connected SQL Server) 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 | MSQBLOCPRI | The SPID of the process blocking this SQL process. | |
3 | Data Element | MSQCPUTIME | MS SQL Server total cumulative CPU time for a SQL process | |
4 | Data Element | MSQEXECMD | Command currently being executed by the given process id | |
5 | Data Element | MSQHOSTNE | Hostname of the application server logged into SQL Server. | |
6 | Data Element | MSQLTBATTM | Last time a stor. proc. or EXEC was executed on SQL process. | |
7 | Data Element | MSQNETADDR | Unique ID of the network interface of client (MAC address). | |
8 | Data Element | MSQNETLIB | The network library the client is using. | |
9 | Data Element | MSQNTDOMA | NT domain for the client connected to SQL Server. | |
10 | Data Element | MSQNTUNAME | Windows NT user name for the process connected to SQL Server | |
11 | Data Element | MSQPHYSIIO | The total cumulative disk reads and writes for the process. | |
12 | Data Element | MSQPRCECID | Execution context ID used to uniquely identify subthreads | |
13 | Data Element | MSQPRLGTME | The time at which client process logged into SQL Server. | |
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 | MSQSAPWAIT | Name of the locked resource the process is waiting for. | |
17 | Data Element | MSQSERPRID | SQL Server process ID | |
18 | Data Element | MSQSQLWAIT | The locked resource process is waiting for (object ID). | |
19 | Data Element | MSQTHREADI | Windows operating system thread ID of SQL process | |
20 | Data Element | MSQUSRNAME | The user name used to log into the SQL Server database | |
21 | Data Element | MSQWAITIME | Current wait time of the process in milliseconds | |
22 | Data Element | MSQWAITRES | The last wait event the process had to wait for.. | |
23 | Data Element | MSQWAITYPE | The wait type of the waiting process. | |
24 | Data Element | MSQWKPROID | The application program's process ID on the given host | |
25 | Data Element | MSSDB | Database name | |
26 | Data Element | MSSOPENTRAN | Number of open transactions for the SQL Server process |