Solution : https://service.sap.com/sap/support/notes/1496753 (SAP Service marketplace login required)
Summary : 
      This SAP Note addresses performance issues due to a slow SELECT operation on RSSTATMANREQMAP in the RSS2_CHECK_DM_FOR_VALID_SID function module. The introduction of a secondary index for the RNSIDLAST field in RSICCONT is proposed to enhance performance. Users of SAP NetWeaver BW (various versions) are advised to import specific Support Packages as detailed to rectify the slowdown and stabilize system behavior. Additional instructions for creating new indices and pre-implementing corrections in urgent cases with reference to Note 875986 for guidance using SNOTE are provided.
Key words : 
software component   sap_bw                        business inform, solution sap netweaver bw 7, sap netweaver bw 7, manual pre-implement, sap nw bw 7, -unique sid index, 01 bw abap sp08, 30 bw abap sp01, sapbinews nw bi 7, sid secondary index
Related Notes : 
       
| 1471463 | SAPBWNews NW BW 7.01 ABAP SP08 | 
| 1468668 | SAPBWNews NW7.0 BW ABAP Support Package 25 | 
| 1450990 | SAPBWNews NW BW 7.02 ABAP SP05 | 
| 1392433 | SAPBINews NW7.11 BW ABAP Support Package 05 |