Symptom
The database times required to execute a join using MSEG and MKPF are high.
Other terms
column statistics; BUDAT; performance
Reason and Prerequisites
The system is running on Microsoft SQL Server.
The MKPF table contains data for material documents. There is a secondary index on the BUDAT column (posting date) that usually only contains values up to the [...]
Symptom
For Release NetWeaver2004s (Basis Release 7.00), we developed a completely new workload statistics collector to meet the requirements of large systems. This newly developed workload statistics collector is incompatible with earlier workload statistics data. After you upgrade to Netweaver2004s, you can no longer display workload statistics data in ST03N that has [...]
Symptom
This note provides answers to the most frequently asked questions about MaxDB Administration.
1. What are the tasks of a MaxDB database administrator?2. What administration tools are available?3. Can administration tasks be automated?4. Is there a central transaction in the SAP system for all administrative database activities?5. Where can I find more information about MaxDB CCMS?6. [...]
Symptom
1. What are database statistics used for?2. When are database statistics not required?3. What type of information is covered by database statistics?4. What are histograms?5. How damaging are old statistics?6. What are the disadvantages of creating new statistics?7. How can I restore old statistics?8. How can database statistics be created?9. How does BRCONNECT proceed when [...]
Symptom
You don’t see any or only incomplete work center related information in transaction STATTRACE and/or you SAP Live Link data collector WORKCENTER_ACTUAL_USAGE doesn’t deliver any data.
You could check this by running transaction STATTRACE, selecting data from a suitable period and filtering on service type ‘Portal’.
If you don’t get any data in the work [...]
Symptom
This note deals with questions and answers regarding MaxDB/liveCache Heap-Management. However, it is not exhaustive. This note is aimed at MaxDB/liveCache experts.
The main focus of this note lies on the analysis options regarding the following topics: How is the memory consumption of the MaxDB/liveCache kernel process distributed?.
For the implementation of the note you [...]
Symptom
The performance of Oracle 9i or higher is poor. This is due to unfavorable decisions by the Cost Based Optimizer.
Reason and Prerequisites
In certain situations, the Cost Based Optimizer (CBO) may make unfavorable decisions, although there are no CBO errors, for example:
Tables with heavily fluctuating volumes of data (Note 756335)Selective conditions on columns that do [...]