SAP ABAP Message Class SMMSS_ALERTS Message Number 011 (This alert tracks the percentage of CPU used by SQL Server)

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

Attribute

Message class	SMMSS_ALERTS
Short Description	Message class for MSSQL rz20 messages
Message Number	011
Documentation status		Space: object requires documentation
Authorization check Error Message	☐
Changed On	20130531

Message Text

This alert tracks the percentage of CPU used by SQL Server

Help Document

Diagnosis

This alert shows the percentage of cpu capacity on the database server used by SQL Server. The value is taken from the global variable @@cpu_busy. The threshhold values are set depending on whether a stand alone database server is in use, or if an SAP instance exists on the database server also.

System Response

Procedure

If the threshhold values are incorrect, right click on the object and select properties. Then, customize the values to your liking. If the threshhold values are being reached, try to off load computing tasks from the database server or add cpus.

Procedure for System Administration

History

Last changed on/by	20130531	SAP
SAP Release Created in