SAP with Microsoft SQL Server 2005: Best Practices for High Availability, Maximum Performance, and Scalability60
The sample in Figure 23 shows that the Query Plan Display of SQL Server 2005 can also be used to view the query execution plan. If the analysis is performed immediately after the trace is taken, the query execution plan is usually in the displayed cache. If the analysis is performed at a later time after the trace is taken and the trace is no longer in cache, a new query execution plan is created. Unfortunately, there is no easy way to determine if the execution plan is in cache or if it was newly generated.
ST04 Database Monitor transaction
Query performance statistics are available only by using the SAP ST04 Database Monitor transaction. ST04 is used to view the SAP database operations. This is useful, for example, to verify the database status and statistics when query performance is not clearly reproducible or the query cannot be rerun.
The ST04 transaction is typically the only way SAP support can monitor the database in depth. ST04 displays all types of data collected in the database instance. ST04 can be used to check values, including the cache hit ratio, errorlogs of SQL Server, and different values such as wait statistics.
The ST04 transaction pages display an overview, details, query statistics, query performance statistics, and query details as follows.
Microsoft Corporation © 2005