A customer experiences right now a dramatic decline in
performance, what will you do?
Answers were Sorted based on User's Feedback
Answer / inder09
By combining the functions of SM50/SM66 and ST04 you are
able to answer
You can find what report is accessing what table. Also you
can identify the user who started this report.
You find what select statement accesses what table, and you
can get an "Explain" for it
Using ST04 you can identify what kind of table access is
used to retrieve data from the database
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / srikanth
Check the logon groups to see if there ia a heavy load on
any particular server. If it is, then have the users to
logoff and login again using someother instance. Check for
sm12 locks. See if there are some exclusive locks on any
particular table. sometimes it may happen that a particular
table may be accessed by some user and others are trying to
access it and waiting for it.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / nani
To analyze the performance in SAP system we use below
transactions:
Application level:
ST03,ST02,SM50,SM21
Database Level:
DB02,DB13(Update table statistics),ST04,ST05
OS Level:
ST06
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / prvn
Go to ST03->Expert->Total
Check for the average responce time
| Is This Answer Correct ? | 1 Yes | 2 No |
Can you create a table with fields not referring to data elements?
What is Remote Transaction Processing?
In an SAP system, while using the Transaction DB02 there are Swaps figures that are RED, How can one solve this problem....
Why do you use DDIC user not SAP* for Support Packs and SPam?
What is the use of Trusted system? I know that there is no need of UID and PWD to communicate with partner system. In what situation it is good to go for Trusted system?
In sap basis what are the different types of transport requests?
What is SAP R/3?
When you use DB02 Transaction, You see something called as Swaps, What are they, and how the increase in swaps does affect your SAP system Performance
how to create list of users available in a client?
who is the owner of sap like owner of .net frame work is Microsoft?
Hi can any one tell me the path to trans.log file in both(unix and windows ) environment
Is sap a database ?
SAP Basis (1262)
SAP ABAP (3939)
SAPScript (236)
SAP SD (Sales & Distribution) (2717)
SAP MM (Material Management) (912)
SAP QM (Quality Management) (99)
SAP PP (Production Planning) (523)
SAP PM (Plant Maintenance) (252)
SAP PS (Project Systems) (138)
SAP FI-CO (Financial Accounting & Controlling) (2766)
SAP HR (Human Resource Management) (1180)
SAP CRM (Customer Relationship Management) (432)
SAP SRM (Supplier Relationship Management) (132)
SAP APO (Advanced Planner Optimizer) (92)
SAP BW (Business Warehouse) (896)
SAP Business Workflow (72)
SAP Security (597)
SAP Interfaces (74)
SAP Netweaver (282)
SAP ALE IDocs (163)
SAP Business One (110)
SAP BO BOBJ (Business Objects) (388)
SAP CPS (Central Process Scheduling) (14)
SAP GTS (Global Trade Services) (21)
SAP Hybris (132)
SAP HANA (700)
SAP PI (Process Integration) (113)
SAP PO (Process Orchestration) (25)
SAP BI (Business Intelligence) (174)
SAP BPC (Business Planning and Consolidation) (38)
SAP BODS (Business Objects Data Services) (49)
SAP BODI (Business Objects Data Integrator) (26)
SAP Ariba (9)
SAP Fiori (45)
SAP EWM (Extended Warehouse Management) (58)
Sap R/3 (150)
SAP FSCM Financial Supply Chain Management (101)
SAP WM (Warehouse Management) (31)
SAP GRC (Governance Risk and Compliance) (64)
SAP MDM (Master Data Management) (0)
SAP MRS (Multi Resource Scheduling) (0)
SAP ESS MSS (Employee Manager Self Service) (13)
SAP CS (Customer Service) (0)
SAP TRM (Treasury and Risk Management) (0)
SAP Web Dynpro ABAP (198)
SAP IBP (Integrated Business Planning) (0)
SAP OO-ABAP (Object Oriented ABAP) (70)
SAP S/4 HANA Finance (Simple Finance) (143)
SAP FS-CD (Collections and Disbursements) (0)
SAP PLM (Product Lifecycle Management) (0)
SAP SuccessFactors (33)
SAP Vistex (0)
SAP ISR (IS Retail) (28)
SAP IdM (Identity Management) (0)
SAP IM (Investment Management) (0)
SAP UI5 (59)
SAP SCM (Supply Chain Management) (51)
SAP XI (Exchange Infrastructure) (49)
SAP Cloud Platform (34)
SAP Testing (89)
SAP SolMan (Solution Manager) (63)
SAP MaxDB (116)
SAP GUI (15)
SAP AllOther (329)