Table/Structure Field list used by SAP ABAP Function Module GET_DYNAMICSERVER_MSQ (retrieve data about sql server available from the @@variables)
SAP ABAP Function Module 
GET_DYNAMICSERVER_MSQ (retrieve data about sql server available from the @@variables) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Table/Structure Field |
DBCON - CON_NAME | Logical name for a database connection | SOURCE VALUE(CON_NAME) TYPE DBCON-CON_NAME DEFAULT 'DEFAULT' |
| 2 | Table/Structure Field |
DBCON - CON_NAME | Logical name for a database connection | |
| 3 | Table/Structure Field |
MSQ_DYSERV - TOTALREAD | Number of disk reads done by SQL Server (physical reads). | |
| 4 | Table/Structure Field |
MSQ_DYSERV - TOTALWRITE | Number of physical disk writes done by SQL Server. | |
| 5 | Table/Structure Field |
MSQ_DYSERV - TOTALERROR | Number of disk read or write errors since SQL Server started | |
| 6 | Table/Structure Field |
MSQ_DYSERV - SQLUPTIME | Number of seconds SQL Server has been running. | |
| 7 | Table/Structure Field |
MSQ_DYSERV - PCTIO | Percent of time SQL Server tasks have beeen busy whit IO. | |
| 8 | Table/Structure Field |
MSQ_DYSERV - PCTIDLE | Percent of time CPUs have been idle. | |
| 9 | Table/Structure Field |
MSQ_DYSERV - PCTCPU | Percent of time the CPUs have been busy. | |
| 10 | Table/Structure Field |
MSQ_DYSERV - PACKRECD | Number of network packets received. | |
| 11 | Table/Structure Field |
MSQ_DYSERV - PACKERRORS | Number of network packets with error since SQL Server start. | |
| 12 | Table/Structure Field |
MSQ_DYSERV - IOBUSY | Number of seconds SQL Server tasks were busy with IO. | |
| 13 | Table/Structure Field |
MSQ_DYSERV - CPUIDLE | Number of seconds CPUs have been idle (sum for all CPUs) . | |
| 14 | Table/Structure Field |
MSQ_DYSERV - CPUBUSY | Number of seconds CPUs have been busy (sum for all CPUs) . | |
| 15 | Table/Structure Field |
MSQ_DYSERV - CONNECTS | Number of attempted connections to SQL Server. | |
| 16 | Table/Structure Field |
MSQ_DYSERV - PACKSENT | Number of network packets sent out by SQL Server. | |
| 17 | Table/Structure Field |
MSSCOLLODESC - CNTR_NAME | MSSCOLLODESC-CNTR_NAME | |
| 18 | Table/Structure Field |
MSSCOLLODESC - OBJ_NAME | MSSCOLLODESC-OBJ_NAME | |
| 19 | Table/Structure Field |
MSSCOLLRESI - CNTR_VALUE | MSSCOLLRESI-CNTR_VALUE | |
| 20 | Table/Structure Field |
MSSCOLLRESI - SLOPE | MSSCOLLRESI-SLOPE | |
| 21 | Table/Structure Field |
MSSCOLLRESI - OBJ_NAME | MSSCOLLRESI-OBJ_NAME | |
| 22 | Table/Structure Field |
MSSCOLLRESI - CNTR_NAME | MSSCOLLRESI-CNTR_NAME | |
| 23 | Table/Structure Field |
SYST - MSGID | ABAP System Field: Message ID | |
| 24 | Table/Structure Field |
SYST - MSGNO | ABAP System Field: Message Number | |
| 25 | Table/Structure Field |
SYST - MSGTY | ABAP System Field: Message Type | |
| 26 | Table/Structure Field |
SYST - MSGV1 | ABAP System Field: Message Variable | |
| 27 | Table/Structure Field |
SYST - MSGV2 | ABAP System Field: Message Variable | |
| 28 | Table/Structure Field |
SYST - MSGV3 | ABAP System Field: Message Variable | |
| 29 | Table/Structure Field |
SYST - MSGV4 | ABAP System Field: Message Variable |
