Query Tracing

RT Users
1

Hello All

I want to trace queries that are dynamically firing in RT to track where
they are making application slow. But I m not able to find out from where
all queries are fired and from which file. My main concern is to trace
Insert query for ticket creation and Update queries. Do any one has idea
where I can find all this queries in which file.

Any help is highly appreciated.

Thanks & Regards

Varun Vyas

2

Varun;

I think I have mailed you this before, to log the sql queries within RT
you need to add the following line to you RT_SiteConfig.pm file

DBIx-SearchBuilder 1.31_1 or higher; simply set $StatementLog to be

the level that you wish SQL statements to be logged at.

Set($StatementLog,1);

Then restart the web server, at that point any sql query called will be
logged to your rt.log file, if not enough logging is been written you
can increase the level of logging by increasing 1 to 2 or 3 (not sure
what each level log).

Also I would recommend you log at the sql level , not sure about Oracle
but I am sure there is a tool or variable to allow you to log slow
queries some where, or you can once you do show queries from the oracle
commend line during creating a ticket.

By the way what version of DBIx::SearchBuilder and DBD you have
installed, have you googled for common problems with the versions you
have installed.
You can determine the version of modules you have installed by browsing
to your:
https://YOUR_RT_URL/Admin/Tools/Configuration.html

Roy

Varun wrote:

3

Well

I have already made the changes u told me .But still I m not getting any
queries logged in my rt.log(Don’t know why is it bcoz of log level which I
set or something else :frowning: ). And I have DBIx::SearchBuilder 1.55 and
DBD::Oracle v1.19.From: Raed El-Hames [mailto:rfh@vialtus.com]
Sent: Thursday, July 02, 2009 2:03 PM
To: Varun
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Query Tracing

Varun;

I think I have mailed you this before, to log the sql queries within RT
you need to add the following line to you RT_SiteConfig.pm file

DBIx-SearchBuilder 1.31_1 or higher; simply set $StatementLog to be

the level that you wish SQL statements to be logged at.

Set($StatementLog,1);

Then restart the web server, at that point any sql query called will be
logged to your rt.log file, if not enough logging is been written you
can increase the level of logging by increasing 1 to 2 or 3 (not sure
what each level log).

Also I would recommend you log at the sql level , not sure about Oracle
but I am sure there is a tool or variable to allow you to log slow
queries some where, or you can once you do show queries from the oracle
commend line during creating a ticket.

By the way what version of DBIx::SearchBuilder and DBD you have
installed, have you googled for common problems with the versions you
have installed.
You can determine the version of modules you have installed by browsing
to your:
https://YOUR_RT_URL/Admin/Tools/Configuration.html

Roy

Varun wrote:

Hello All

I want to trace queries that are dynamically firing in RT to track
where they are making application slow. But I m not able to find out
from where all queries are fired and from which file. My main concern
is to trace Insert query for ticket creation and Update queries. Do
any one has idea where I can find all this queries in which file.

Any help is highly appreciated.

Thanks & Regards

Varun Vyas