MSSNETCHECK - capture db and network times for known query for SQL Server
capture db and network times for known query for SQL Server information is stored in SAP table MSSNETCHECK.
It is part of development package STUN_MSS in software component BC-DB-MSS. This development package consists of objects that can be grouped under "Package for new SQL Server monitoring objects".
It is part of development package STUN_MSS in software component BC-DB-MSS. This development package consists of objects that can be grouped under "Package for new SQL Server monitoring objects".
Fields for table MSSNETCHECK
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SAMPLEDT | Collection date | X | MSSCOLLDATE | DATS | 16 | |
| SAMPLETM | Collection time | X | MSSCOLLTIME | TIMS | 12 | |
| SERVER | MS SQL Server server to be used for a SQL task execution | X | MSSSERVER1 | CHAR | 60 | |
| DBVALUE | SQL Server int4 | MSSINT4 | INT4 | 4 | ||
| NETVALUE | SQL Server int4 | MSSINT4 | INT4 | 4 | ||
| DBCONCHECK | Flag to identify server as a server reached from a dbcon | MSSDBCONCHECK | CHAR | 2 | ||
| DAYCHECK | Flag to identify dbcon server was down for 24 hours | MSS24HRCHECK | CHAR | 2 |