Solution : https://service.sap.com/sap/support/notes/1085937 (SAP Service marketplace login required)
Summary :
SAP Note provides detailed guidance on analyzing SQL Server wait events within SAP systems. The functional reports, part of the Service Tools Plug-In, are necessary for this analysis, specifically requiring versions ST-PI 2005_1_<Rel> SP 06 or later. Users can collect and monitor wait events continuously or over specific intervals, storing the data in table MONI. Advanced functionalities include exclusions of idle events, grouping by wait event classes, and collecting CPU usage data. The solution enables downloading and analyzing this data locally and suggests referencing note 1152848 for further details on SQL Server wait events.
Key words :
event wait_type total waits waiting_tasks_count requests signal wait time, rfc 3165 convid 85868673 cmrc=18 data=3 status=1 saprc=0 comread mss_tools_authority, enter sm59 delete destination <sid> choose create enter <sid>, displaying wait event history run report /sdf/rsmssvse, enter /sdf/rsmssvshchoose 'variants' -> change -> create, sql server wait eventsfunctionality collecting wait event history, earlywatch_dbmon_<mm><dd>_<hh><mm>, recognize unreasonable high 'total wait time, support package st-pi 2008_1_ sp2, local database run report /sdf/rsmssvse
Related Notes :
| 1235687 | Lack of privileges in DB utilities |
| 1228898 | Installation/delta upgrade of ST-PI 2008_1 |
| 1152848 | FAQ: SQL Server Wait Events |
| 12103 | Contents of the TCOLL table |