how to know if there are expensive sql statements
running?what will you do then to improve the response time?
- 3 Answers
- 11317 Views
- Atos Origin, I also Faced
- E-Mail Answers
Answer Posted / venkatesan k
ST03 ---> Detailed Analysis--> Transaction profile-->
Standard--> Selectb task type as DIA---> Sort the Totao DB
time in Ascending order
ST04--> detailed Analysis--> Resourse Consuption--> Oracle
Seeion Monitor--> Identify the long running task by
comparing that with WP Id.
Double click on the task --> resulting DIA Box--> Explain
SQL statement-->Analyse
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
I also wanna work with Webdynpros? What are the requirements? I mean SAP 4.7 ee or ECC 5 or 6? Netweaver developer Studio? Also with win 2003 i have the activation problem every month. SO do i get a cd that doesnt ask for the activation? i have win 2000 but can it be installed on HP pavilion laptops that are coming preinstalled with Vista OS?
How to configure TMS?
How will determine whether your sap server is unicode or ascii ?
How do you check the installed software components and product versions on sap system?
Explain what is business kpis ?
does the Tcode EWZ5 exist in ECC6?I'm using NW2004S SR2 abap engine and EWZ5 doesn't exist in that.so in that case what is the alternative to EWZ5?to see the list of users present in a client but not necessarily logged in and to to lock or unlock them? Thanks.
What is your organization’s security philosophy? What level of security does your data require? How much risk are you willing to assume in each application area?
How many types of printer you have configured? How do you differentiate between them?
What is heterogenous system copy and homogenous system copy ?
What are the different types of rfc?
How to check cpu usage in EP?
How can a user be able to access only for Customizing requests even if assigned se01 and se10?.
How to setup RFC connection in ecc6 tells me steps involved?
I would like to know the version or name of SAP that is implemented in real time?
Explain what are the functional modules used in sequence in bdc?
