X hits on this document

Word document

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

257 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 views257
Page views257
Page last viewedTue Dec 06 11:07:03 UTC 2016
Pages76
Paragraphs1372
Words23715

Comments