SAP Table MSQPROCESS
MS SQL server processes ( as from sysprocesses )
MSQPROCESS (MS SQL server processes ( as from sysprocesses )) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link MSQPROCESS to other SAP tables.
MSQPROCESS table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| SPID | MS SQL Server process ID | MSQSYPROID | INT2 | 5 | 0 | |||
| KPID | Windows operating system thread ID | MSQTHREDID | INT2 | 5 | 0 | |||
| BLOCKED | SPID of blocking process. | MSQBLOPRID | INT2 | 5 | 0 | |||
| WAITTYPE | Wait type of waiting process, reserved field of sysprocesses | MSQWAITTYP | INT2 | 5 | 0 | |||
| DBID | MS SQL Server database ID | MSQDBASEID | INT2 | 5 | 0 | |||
| USERID | MS SQL Server - user identification ID | MSQUID | INT2 | 5 | 0 | |||
| CPUTIME | MS SQL Server total cumulative CPU time for a SQL process | MSQCPUTIME | INT4 | 10 | 0 | |||
| PHYIO | The total cumulative disk reads and writes for the process. | MSQPHYSIIO | DEC | 20 | 0 | |||
| MEMUSUAGE | The pages allocated by the SQL process in procedure cache. | MSQPRMEMUS | INT4 | 10 | 0 | |||
| LOGINTIME | Login Time for client process or system startup time | MSQLOGTIME | CHAR | 24 | 0 | |||
| LSTBATTIME | Last time exec. of remote stored proc. call or sql stat. | MSQLSTEXST | CHAR | 24 | 0 | |||
| PROSTATUS | SQL Server process status; ie sleeping, running etc. | MSQPROSTAT | CHAR | 60 | 0 | |||
| SIDNAME | The user name used to log into the SQL Server database | MSQUSRNAME | CHAR | 128 | 0 | |||
| HOSTNAME | Hostname of the application server logged into SQL Server. | MSQHOSTNAM | CHAR | 256 | 0 | |||
| PRONAME | Name of the application program which owns the connection. | MSQAPPPROG | CHAR | 256 | 0 | |||
| HOSTPRO | The application program's process ID on the given host | MSQWKPROID | CHAR | 16 | 0 | |||
| CMD | Command currently being executed by the given process id | MSQEXECMD | CHAR | 32 | 0 | |||
| NTDOMAIN | NT domain for the client connected to SQL Server. | MSQNTDOMA | CHAR | 256 | 0 | |||
| NTUNAME | Windows NT user name for the process connected to SQL Server | MSQNTUNAME | CHAR | 256 | 0 | |||
| NETADD | Unique ID of the network interface of client (MAC address). | MSQNETADDR | CHAR | 12 | 0 | |||
| NETLIB | The network library the client is using. | MSQNETLIB | CHAR | 12 | 0 | |||
| SUIDNAME | The user name used to log into the SQL Server database | MSQUSRNAME | CHAR | 128 | 0 | |||
