SAP with Microsoft SQL Server 2005: Best Practices for High Availability, Maximum Performance, and Scalability61
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.
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