Solution : https://service.sap.com/sap/support/notes/819641 (SAP Service marketplace login required)
Key words :
transaction db50 -> current status -> kernel threads-> task managerfirst, selecting current status -> kernel threads -> task manager, transaction db50 -> current status -> activities overview -> log_io_queue overflow, includes fully-qualified primary key accesses, transaction db50 problem analysis -> performance -> database analyzer -> bottlenecks, transaction db50 -> problem analysis -> performance -> database analyzer, -> current status -> memory areas -> caches, transaction db50 current status -> system settings, maxdb/sap db performance monitoring & optimizationthis, x_cons <dbname> t_c <task-id>
Related Notes :
| 1266771 | SRM 7.0 Performance Guide |
| 1169088 | SRM 6.0 Performance Guide |
| 1139904 | FAQ: MaxDB/liveCache kernel parameters |
| 1076804 | Incomplete update records |
| 1006496 | Feature list for SAP MaxDB/liveCache 7.7 |
| 993848 | Direct I/O mount options for liveCache/MaxDB |
| 936058 | FAQ: SAP MaxDB Runtime Environment |
| 928037 | FAQ: SAP MaxDB indexes |
| 889038 | Collective note: NWDI server component configuration |
| 832544 | FAQ: MaxDB Hints |
| 819324 | FAQ: SAP MaxDB SQL optimization |
| 814704 | MaxDB Version 7.6 parameter settings for OLTP/BW |
| 808060 | Changing the estimated values for Update Statistics |
| 806690 | Feature list for SAP MaxDB/liveCache 7.6 |
| 767635 | MaxDB Version 7.5 parameter settings for OLTP/BW |
| 767598 | Available SAP MaxDB documentation |
| 748225 | Measuremnt I/O times on liveCache/SAP DB/MaxDB DATA/LOG Vol |
| 725489 | MaxDB performance analysis tools |
| 710166 | Feature list for liveCache/MaxDB 7.5.00 |
| 710165 | Feature list for liveCache/SAP DB 7.4.03 |
| 685873 | Feature list for SAP DB 7.3.00 |
| 579462 | Runtime parameter of the statistics collection |
| 545385 | SQL error -1104 during Prepare |
| 500235 | Network Diagnosis with NIPING |
| 140739 | SQL error -1114 COMMUNICATION PACKET TOO SMALL |