Data Element list used by SAP ABAP Table MSS_REQUEST (sys.dm_exec_requests structure from SQL Server 9.0)
SAP ABAP Table 
MSS_REQUEST (sys.dm_exec_requests structure from SQL Server 9.0) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Data Element |
MSQEXECMD | Command currently being executed by the given process id | |
| 2 | Data Element |
MSQPROSTAT | SQL Server process status; ie sleeping, running etc. | |
| 3 | Data Element |
MSQSAPWAIT | Name of the locked resource the process is waiting for. | |
| 4 | Data Element |
MSQSQLWAIT | The locked resource process is waiting for (object ID). | |
| 5 | Data Element |
MSQUSRNAME | The user name used to log into the SQL Server database | |
| 6 | Data Element |
MSQWAITIME | Current wait time of the process in milliseconds | |
| 7 | Data Element |
MSSBLKSESSIONID | Blocking session ID for SQL Server | |
| 8 | Data Element |
MSSDB | Database name | |
| 9 | Data Element |
MSSESTCMPTIME | Estimated Completion time of SQL Request | |
| 10 | Data Element |
MSSINT4 | SQL Server int4 | |
| 11 | Data Element |
MSSINT4 | SQL Server int4 | |
| 12 | Data Element |
MSSOPENRES | Number of open result sets for the SQL Server process | |
| 13 | Data Element |
MSSOPENTRAN | Number of open transactions for the SQL Server process | |
| 14 | Data Element |
MSSPARTIALSQL | First 50 characters of a SQL Server statement | |
| 15 | Data Element |
MSSPLANHANDLE | handle pointing to plan used in execution of sql stmt/proc | |
| 16 | Data Element |
MSSPRCCOMP | Percentage complete | |
| 17 | Data Element |
MSSREQCONNID | SQL Server connection id | |
| 18 | Data Element |
MSSREQCPUTIME | CPU time for a request | |
| 19 | Data Element |
MSSREQDATE | Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS | |
| 20 | Data Element |
MSSREQNUMLOGRDS | number of reads performed by a request | |
| 21 | Data Element |
MSSREQNUMREADS | number of reads performed by the request | |
| 22 | Data Element |
MSSREQNUMWRITES | number of writes performed in a request | |
| 23 | Data Element |
MSSREQSCHEDULERID | ID of the scheduler used for the request | |
| 24 | Data Element |
MSSREQSID | Session ID associated with the request being processed | |
| 25 | Data Element |
MSSREQTTL | Total elapsed time utilized by a request | |
| 26 | Data Element |
MSSREQUESTID | SQL Server Request ID | |
| 27 | Data Element |
MSSROWCOUNT | SQL Server count of rows returned | |
| 28 | Data Element |
MSSSQLHANDLE | handle pointing to sql statment or procedure | |
| 29 | Data Element |
MSSTRANSACTIONID | Transaction identifier request executes under |
