Solution : https://service.sap.com/sap/support/notes/159171 (SAP Service marketplace login required)
Key words :
sp_recompile, dbs/mss/max_duration, Optimizer Hints
Related Notes :
| 1545696 | Poor runtime behavior in systems with MSSQL database |
| 1148380 | client awareness |
| 1124574 | Performance improvement for 'SQL Server' in trans SXMB_MONI |
| 792258 | Application log: Performance of BALHDR in MSSQL database |
| 724047 | performance problems after client import |
| 687864 | Performance problem following upgrade to 6.20 basis. |
| 489690 | CC INFO: Copying large production clients |
| 208919 | CC-INFO: Performance as of Release 4.6 |
| 155413 | Analysis of slow SQL statements |
| 133381 | Database-Hints in Open SQL for MS SQL Server |
| 129385 | Database hints in Open SQL |
| 67205 | CC-INFO: Copying large and productive clients |