[rt-users] Query Tracing

[Varun]

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 :( ). And I have DBIx::SearchBuilder 1.55 and
DBD::Oracle v1.19.


-----Original Message-----
From: Raed El-Hames [mailto:rfh at vialtus.com] 
Sent: Thursday, July 02, 2009 2:03 PM
To: Varun
Cc: rt-users at 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
>
>  
>