Skip to end of metadata
Go to start of metadata

Purpose

This section describes key MS SQL Server-specific steps to troubleshoot ME application performance problems.

For ease of use in viewing an SAP Note, right click on the Note link and select Open in new window or Open in new tab.

Overview

Verify database settings

Verify database settings according to SAP Note 1405261  - 'SAP ME Databases: MS SQL Server Recommendations'

Check MS SQL Server performance reports

  • Run SQL Server Management Studio
  • Right-click database name -> Reports -> Standard Reports
  • Choose the report that addresses the reported performance issue
  • Top transactions reports will show the long-running and resource-intensive transactions

     Select the image to expand it.

Check Windows performance monitor

  • Start -> Run -> perfmon
           Select the image to expand it.
  • Right-click on graph and choose Add Counters
  • Counters for SQL Server are in list of available counters

     Select the image to expand it.

Related Notes

SAP Note 1405261  - 'SAP ME Databases: MS SQL Server Recommendations'

  • No labels