The Alert Monitor for the SQL Server enables you to get a quick overview of important information that is relevant for the operation of the database. It draws attention to existing and potential problems with colored alerts and offers easy access to in-depth information about the system.
Prerequisites
To access the Alert Monitor for the SQL Server, you choose CCMS → Control/Monitoring → Alert monitor. Alternatively enter the transaction code RZ20. In the monitoring tree, expand SAP SQL Server Monitor and double-click on SQLServer.
Features
Information in the monitor is presented in the form of a tree that can be expanded to get a quick overview of the current status of the database. When a given threshold value defined for the database is exceeded, this is shown by alerts that are red or yellow. Red indicates an existing problem that must be resolved and yellow a situation, which could develop into a problem.
The information provided in the tree can be viewed from different perspectives.
In addition, a further option allows you to start an Analysis Tools, which accesses comprehensive information about a selected aspect of database or system performance.
Categories of Information
Information and alerts for SQL Server in the monitoring tree are grouped into the following main categories:
For more information on these categories seeAlerts for the Database Server.