X hits on this document

Word document

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

366 views

0 shares

0 downloads

0 comments

65 / 76

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

Overview page

The ST04 Overview page illustrated in Figure 24 provides general SQL Server 2005 information, including the operating system release on which SQL Server runs. The most important information includes the cache hit ratio numbers and the trace flags used.

Figure 24

Details page

In Figure 25, the ST04 Details page selections include:

Checks on the errorlogs and a list of deadlocks.

Checks for immediate blocking lock situations or statistics on lock situations of over one minute.

Checks for performance problems using SAP statistics on stored procedures.

Microsoft Corporation © 2005

Document info
Document views366
Page views366
Page last viewedMon Jan 23 21:49:16 UTC 2017
Pages76
Paragraphs1372
Words23715

Comments