X hits on this document

Word document

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

295 views

0 shares

0 downloads

0 comments

63 / 76

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.

Figure 21

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

Document info
Document views295
Page views295
Page last viewedSun Dec 11 03:07:47 UTC 2016
Pages76
Paragraphs1372
Words23715

Comments