SAP ABAP Message Class SMMSS_ALERTS Message Number 064 (This alert shows the ms/access)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-MSS (Application Component) Microsoft SQL Server
⤷
STUN_MSS (Package) Package for new SQL Server monitoring objects
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-MSS (Application Component) Microsoft SQL Server⤷
STUN_MSS (Package) Package for new SQL Server monitoring objects 
Attribute
| Message class |  |
SMMSS_ALERTS | |
| Short Description |  |
Message class for MSSQL rz20 messages | |
| Message Number |  |
064 | |
| Documentation status | Space: object requires documentation |
||
| Authorization check Error Message | |||
| Changed On |  |
20130531 |
Message Text
This alert shows the ms/access
Help Document
Diagnosis
This alert shows the millisecs per access for each file which makes up the database. The time is calculated by querrying the system function ::fn_virtualfilestats and dividing the column IoStallMS by the the total number of reads and writes.
System Response
Procedure
If alerts are displayed for access times more the 10ms / access, then consider reengineering the i/o system being measured. More disk i/o could be added, or the file layout changed to achieve better performance.
Procedure for System Administration
History
| Last changed on/by | |
20130531 | SAP |
| SAP Release Created in |
