SAP with Microsoft SQL Server 2005: Best Practices for High Availability, Maximum Performance, and Scalability59
The SAP Fetch phase is used to count the time required to retrieve the data from the database server to the application server. Most often, the Fetch time is the smaller amount of time, unless large numbers of rows are returned.
In ST05, double-click the open line of a statement to display the full statement and its parameters. At the end of the statement text, the stored procedure name or the dynamic Transact-SQL statement string provides SQL Server port-specific information about how the Transact SQL statement from ABAP was executed in SQL Server 2005.
ST05 indicates when there is no server-side cursor on the committed read connection only. For example, the description conn 0:1 indicates that connection number 1 of the SAP process was used to execute the statement.
Because the enumeration starts with 0, connection 1 is the uncommitted read connection.
The ST05 sample in Figure 22 shows that, by marking the statement, the ABAP coding that triggers the database statement can be reviewed. This permits a deeper analysis of the ABAP code to be performed to achieve improvements.
Microsoft Corporation © 2005