SAP with Microsoft SQL Server 2005: Best Practices for High Availability, Maximum Performance, and Scalability54
In addition, the dialog process shows that 224.7 ms were spent using the application servers CPUs, with 282.4 ms on average spent accessing the database.
Note that the database response time for the dialog process should be below 50 percent and not higher than 50 to 60 percent for typical interactive SAP transactions.
Performance (Several Days)
The ST03 sample in Figure 19 provides a summary of performance, such as the times spent in the different components, over the last 30 days. ST03 provides an overview of the work generated by the SAP application layer and shows all process types. Note that the sample shows a history of the number of dialog steps.
Severe changes to components such as application server hardware or database server hardware should become visible by lowering the response times in the particular column.
Microsoft Corporation © 2005