How To Fix SMMSS_ALERTS090 - This alert shows the name of the object which caused high cpu %

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 090

• Message text: This alert shows the name of the object which caused high cpu %

Self-Explanatory Message

Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of messages in the SAP system have a message text, however this is frequently insufficient to comprehend or resolve the problem.

To make things easier, more detailed information is frequently added to describe the issue, how to fix it, and the necessary steps or configuration modifications.

Unfortunately, there isn't any extra information in this error notice.

What else can you do?

First, use our AnswerBot below to get a possible cause and solution (requires a premium subscription).

Also, review the in-depth Common Questions & Answers listed below; you could discover a solution there or be able to connect with others who have faced similar challenges.

You can also try searching the SAP support portal (support.sap.com) but you need a special user ID to access it. It is possible that an SAP support note exists that provides additional details about the mistake or even steps for fixing it.

Smart SAP Assistant

• What is the cause and solution for SAP error message SMMSS_ALERTS090 - This alert shows the name of the object which caused high cpu % ?

  The SAP error message SMMSS_ALERTS090 indicates that a specific object in your SAP system is causing high CPU usage. This alert is part of the SAP Solution Manager's monitoring capabilities, which helps administrators identify performance issues in the system.
  Cause:
  The high CPU usage can be attributed to various factors, including but not limited to:
  
  Inefficient Code: Poorly written ABAP programs or custom code that consumes excessive CPU resources.
  Database Performance: Inefficient SQL queries or database locks that lead to high CPU consumption.
  Background Jobs: Long-running or resource-intensive background jobs that are consuming CPU.
  System Configuration: Misconfiguration of system parameters that may lead to inefficient resource utilization.
  High Load: Increased user activity or transactions that put a strain on the system.
  
  Solution:
  To address the high CPU usage indicated by the SMMSS_ALERTS090 alert, you can take the following steps:
  
  
  Identify the Object: Review the alert details to identify the specific object (e.g., program, transaction, or job) that is causing the high CPU usage.
  
  
  Analyze Performance:
  
  Use transaction ST05 (SQL Trace) to analyze database performance and identify slow-running queries.
  Use transaction ST12 (ABAP Trace) to analyze ABAP code performance.
  Check transaction SM50 or SM66 to monitor active processes and identify which processes are consuming high CPU.
  
  
  
  Optimize Code: If the issue is related to custom ABAP code, consider optimizing the code to improve performance. This may involve:
  
  Refactoring inefficient algorithms.
  Reducing database calls.
  Using appropriate indexing.
  
  
  
  Review Background Jobs: Check for any long-running background jobs in transaction SM37. If necessary, reschedule or optimize these jobs.
  
  
  System Configuration: Review system parameters and configurations to ensure they are optimized for your workload. This may involve adjusting memory settings, CPU allocation, or other performance-related parameters.
  
  
  Monitor Regularly: Set up regular monitoring and alerts to catch high CPU usage early. Use SAP Solution Manager or other monitoring tools to keep track of system performance.
  
  
  Consult SAP Notes: Check the SAP Support Portal for any relevant SAP Notes that may address known issues related to high CPU usage.
  
  
  Related Information:
  
  SAP Notes: Search for SAP Notes related to performance issues and high CPU usage for specific transactions or programs.
  SAP Community: Engage with the SAP Community for insights and solutions from other users who may have faced similar issues.
  Performance Tuning Guides: Refer to SAP's performance tuning guides for best practices on optimizing SAP systems.
  
  By following these steps, you should be able to identify the root cause of the high CPU usage and implement appropriate solutions to mitigate the issue.