SAP with Microsoft SQL Server 2005: Best Practices for High Availability, Maximum Performance, and Scalability62
Query Statistics page
In Figure 26, the ST04 Query Statistics page shows the performance data that was accumulated by each application server or by selected application servers.
Query Performance Statistics page
The sample in Figure 27 shows the ST04 Query Performance Statistics page. ST04 displays the performance numbers for the top executed queries. The list is sorted by the sum of execution times including the fetch time, maximum execution time per query, number of executions, average rows returned per execution, and average execution time.
Query Details page
If the statement is not in the cache, SQL Server generates a new query execution plan based on the parameters of the longest execution of the query. Because SAP specifies the primary key for each update, viewing the query execution plan is not necessary.
Note that in the new Database Monitor SAP releases with NetWeaver 2004S, the parameters used for creating the query execution plan will be shown with SQL Server 2005.
Microsoft Corporation © 2005