Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > Performance & Tuning

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 15th February 2002, 07:07
prajesh's Avatar
prajesh prajesh is offline
Junior Member
 
Join Date: Jan 2002
Location: India
Posts: 11
prajesh is on a distinguished road
Baan: baan4c4 - DB: oracle - OS: unix
Question How to use TT_SQL_TRACE

Hello

can anyone help me out .....

when I run a particular session I want to monitor peformance the sql queries. By Using TT_SQL_TRACE we can do it.

But I dont know How to do it.

As I had seen in of your posted answer the below output

Tracing on: TT_SQL_TRACE = 0200
================================================
Fetch times of Query (QID : 1) Trans 1 (bshell(main)) in SqlBreak :

select count(*):list_size
from ttdsk355


------------------------------------------------
Nr Rows Fetched : 1
Fetch Time for 1st Row : 0.030 sec
Total Time : 0.030 sec
================================================
================================================
Fetch times of Query (QID : 2) Trans 1 (bshell(main)) in SqlBreak :

select ttdsk360.*
where
(ttdsk360.user = :logname$ or ttdsk360.user = :1)
order by ttdsk360.user desc, ttdsk360.cpac desc,
ttdsk360.rsst desc, ttdsk360.rsid desc

------------------------------------------------
Nr Rows Fetched : 180
Fetch Time for 1st Row : 0.080 sec
Max Fetch Time : 0.080 sec
Average Fetch Time : 0.000 sec
Average Fetch Time (except Max) : 0.000 sec
Total Time : 0.080 sec
==============================================
==============================================

so here my point is to get the output as above for my particular session.
could you pls send me tell me the step by step procedure
It will be very helpful for improving the performance of some sql
queries.

pls mail me to this mail id tp12345in@yahoo.com

Thanks in Advance

Regards
Rajesh.
__________________
Raj

Last edited by Han Brinkman : 15th February 2002 at 09:03.
Reply With Quote
  #2  
Old 15th February 2002, 09:05
Han Brinkman's Avatar
Han Brinkman Han Brinkman is offline
Guru
 
Join Date: Aug 2001
Location: The Netherlands
Posts: 1,155
Han Brinkman has a spectacular aura aboutHan Brinkman has a spectacular aura about
Baan: All - DB: Oracle/ms-sql/db2 - OS: *nix/windows
Output

The output is stored in the bshell.<pid> by default.

You can change the location by specifying:
-keeplog -logfile <path/name>

Han
Reply With Quote
  #3  
Old 18th February 2002, 17:52
dmcgrath's Avatar
dmcgrath dmcgrath is offline
Member
 
Join Date: Sep 2001
Location: Nottingham, England
Posts: 41
dmcgrath is on a distinguished road
Baan: Baan IVc3 Sch0 & IVc4 AGS0 - DB: Informix 7.31 UC6 & Informix 9.4 - OS: Solaris 2.6 & Solaris 9
Full Command line

Following on from what Han has mentioned the full command line would be:-

-- -set TT_SQL_TRACE=0200 -logfile <filename> -keeplog

example

-- -set TT_SQL_TRACE=0200 -logfile trace - keeplog

where 'trace' is the filename of the logfile

Note the above is for Baan Windows Interface and is set in BW configuration.

Another useful tracing tool is DBSLOG which can be used on it's own or in conjunction with TT_SQL_TRACE

command line would be

-- -set DBSLOG=<trace code>

example

-- -set DBSLOG=0020

0020 = Table action information

this will create a log file called dbs.log

hope this helps

DLM
Reply With Quote
  #4  
Old 19th February 2002, 11:20
victor_cleto's Avatar
victor_cleto victor_cleto is offline
Guru
 
Join Date: Aug 2001
Location: Portugal
Posts: 776
victor_cleto is on a distinguished road
Baan: none (B40c4 was last) - DB: Oracle - OS: Linux (RHEL)
Options

See the thread http://www.baanboard.com/baanboard/s...s=&threadid=95 for a full description of the options for TT_SQL_TRACE
You can add the values, like, a 240 will do a 000040 (show queries wih their QID) plus a 000200 (show query exec. times)
Reply With Quote
  #5  
Old 20th February 2002, 15:19
dmcgrath's Avatar
dmcgrath dmcgrath is offline
Member
 
Join Date: Sep 2001
Location: Nottingham, England
Posts: 41
dmcgrath is on a distinguished road
Baan: Baan IVc3 Sch0 & IVc4 AGS0 - DB: Informix 7.31 UC6 & Informix 9.4 - OS: Solaris 2.6 & Solaris 9
PEG Tools document on tracing

I have attached a copy of the 'TRACING - Between client and server, server and database, within the bshell, tracing a core dump' version 1.0 Feb 1999 document

This is a 89 page document that covers just about everything you need to know about tracing. I have been informed that a updated version of this document is in the pipeline and I expect to get my hands on this a few months.
Attached Files
File Type: pdf tracing.pdf (509.1 KB, 242 views)

Last edited by patvdv : 10th August 2005 at 23:38.
Reply With Quote
Sponsored Links
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +2. The time now is 10:06.


©2001-2017 - Baanboard.com - Baanforums.com