SAP Note 159171 - Recompilation of Stored Procedures

Component : Microsoft SQL Server -

Solution : https://service.sap.com/sap/support/notes/159171 (SAP Service marketplace login required)

Key words :
resb    ===== ============    100            10    200        500000    300          50000since considerably fewer users, sap profile parameter dbs/mss/max_duration, %_hints mssqlnt 'table <tabname> abindex, profile parameter dbs/mss/max_duration, dbs/mss/max_duration milliseconds, matnr eq x-matnr, parameter bs/mss/max_duration, symptom relational database systems, werks eq x-werks, cost-based query optimizer

Related Notes :

1545696Poor runtime behavior in systems with MSSQL database
1148380client awareness
1124574Performance improvement for 'SQL Server' in trans SXMB_MONI
792258Application log: Performance of BALHDR in MSSQL database
724047performance problems after client import
687864Performance problem following upgrade to 6.20 basis.
489690CC INFO: Copying large production clients
208919CC-INFO: Performance as of Release 4.6
155413Analysis of slow SQL statements
133381Database-Hints in Open SQL for MS SQL Server
129385Database hints in Open SQL
67205CC-INFO: Copying large and productive clients