X hits on this document

Word document

SAP with Microsoft SQL Server 2005: Best Practices for High Availability, Maximum Performance, and ... - page 66 / 76

274 views

0 shares

0 downloads

0 comments

66 / 76

SAP with Microsoft SQL Server 2005: Best Practices for High Availability, Maximum Performance, and Scalability62

Figure 25

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.

Figure 26

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.

Figure 27

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

Document info
Document views274
Page views274
Page last viewedThu Dec 08 14:59:36 UTC 2016
Pages76
Paragraphs1372
Words23715

Comments