How To Fix SMMSS_ALERTS064 - This alert shows the ms/access

SMMSS_ALERTS064 - Overview

• Message type: E = Error

• Message class: SMMSS_ALERTS - Message class for MSSQL rz20 messages

• Message number: 064

• Message text: This alert shows the ms/access

What causes this issue?

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

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

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 Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message SMMSS_ALERTS064 - This alert shows the ms/access ?

  The SAP error message SMMSS_ALERTS064 typically relates to issues with the Microsoft Access database or the Microsoft SQL Server database when using SAP systems. This alert indicates that there is a problem with the database connection or configuration that is affecting the SAP system's ability to access or interact with the database.
  
  Cause:
  
  Database Connection Issues: The SAP system may not be able to connect to the Microsoft Access or SQL Server database due to incorrect connection parameters, such as server name, database name, username, or password.
  Database Configuration: The database may not be configured correctly, or the necessary drivers may not be installed or properly configured.
  Network Issues: There may be network connectivity issues preventing the SAP system from reaching the database server.
  Permissions: The user account being used to connect to the database may not have the necessary permissions to access the database or perform the required operations.
  Database Corruption: The database itself may