I am trying to use the analyser, because I dont know which query is slow... It is a ERP system which I dont have the code...
I get this message: SAP DB Database Analyzer, The Performance Analysis Tool, Version 7.4.3 Copyright (c) 1998-2002 by SAP AG Used protocol directory: /dados/HE/analyzer Used configuration file: /opt/sapdb/indep_prog/env/dbanalyzer74.cfg ERROR 5: Cannot execute SQL statement. [SAP AG][LIBSQLOD SO][SAP DB] Base table or view not found;-4004 POS(937) Unknown table name:RUNNING_PARSEIDS CREATE OR REPLACE VIEW SYSMON_TASK_DETAIL_USER_AR AS SELECT DBPID DBPID, APPL_PROCESS APPL_PID, STATEDESC STATEDESC, DISPATCHCNT DISPATCHCNT, REGIONACCESSCNT REGIONACCESSCNT, COMMANDCNT COMMCNT, TOTCMDEXECUTETIME TOTCMDEXECUTETIME, VSUSPENDCNT VSUSPENDCNT, VSUSPENDTOTABSTIME VSUSPENDABSTIME, VWAITCNT VWAITCNT, VWAITTOTABSTIME VWAITABSTIME, SIOWRITECNT + DIOWRITECNT WRITECNT, SIOREADCNT + DIOREADCNT READCNT, SIOREADTOTABSTIME SIOREADTOTABSTIME, DIOREADTOTABSTIME DIOREADTOTABSTIME, PARSEID PARSEID FROM SYSMON_TASK_DETAIL,RUNNING_PARSEIDS WHERE TASKNAME = 'User' AND NOT STATEDESC LIKE 'Connect wait' AND APPL_PROCESS > 0 AND TASKID(+) = DBPID INTERNAL Can you help me? Best regards, 2006/4/7, Martin Cordova <[EMAIL PROTECTED]>: > A quick one: > > From SQLStudio, run the command "explain YourQueryHere..." > > That will tell you if there are tablescans, which are first candidates > for performance problems, armed with that information you can create > indexes to solve the problem. > > When things get more dificult to diagnose, turn on the analyzer for a > while, it will print some warnings that will guide you to potential > causes for performance problems. > > Hope it helps. > > Regards, > Martin Cordova > -- > Dinamica - RADical J2EE framework > open source, easy and powerful > http://www.martincordova.com > > > > On 4/7/06, Daniel Castro < [EMAIL PROTECTED]> wrote: > > Hi, > > > > I am newbie in SAPDB issues. > > I would like to know which steps do I have to take to identify sapdb > > performance problems. > > I am having a serious performance problem and even though I executed > > "sql_updatestat * ESTIMATE SAMPLE 100 PERCENT" > > the problem is not solved. > > > > Thank you very much. > > > > -- > > Daniel Castro > > Website: http://danielti.no-ip.info:2139 > > MSN: [EMAIL PROTECTED] > > Skype: danielti2005 > > ICQ : 316727989 > > Jabber: danielti > > Linux User: 387864 > > AOL User: Danielti2005 > > Sola Scriptura, Sola Gratia, Sola Fide, Solus Christus, Soli Deo Gloria > > > > > -- Daniel Castro Website: http://danielti.no-ip.info:2139 MSN: [EMAIL PROTECTED] Skype: danielti2005 ICQ : 316727989 Jabber: danielti Linux User: 387864 AOL User: Danielti2005 Sola Scriptura, Sola Gratia, Sola Fide, Solus Christus, Soli Deo Gloria -- Daniel Castro Website: http://danielti.no-ip.info:2139 MSN: [EMAIL PROTECTED] Skype: danielti2005 ICQ : 316727989 Jabber: danielti Linux User: 387864 AOL User: Danielti2005 Sola Scriptura, Sola Gratia, Sola Fide, Solus Christus, Soli Deo Gloria
