CA Clarity Tuesday Tip: The "Surgical SQL Trace"

Discussion created by Shawn_Moore Employee on Aug 1, 2011
Latest reply on Aug 10, 2011 by Dave
Title: CA Clarity Tuesday Tip: The "Surgical SQL Trace"

CA Clarity Tuesday Tip by Shawn Moore, Sr. Principal Support Engineer for 08/01/2011

A little trick that I find useful when performing SQL Traces is what I call the "Surgical SQL Trace."

Basically, our objective is to get the smallest SQL Trace of a page without having all other other actions and page's SQL Tracing present in the file. This can be done rather easily.

Here's how it's done:

1) Navigate to the page in Clarity which you would like to trace.
2) Copy the URL from the browser.
3) Log out.
4) Activate SQL Tracing
5) Paste the URL into your browser URL field. (this will cause a login prompt to appear)
6) Specify your login credentials (You will then be redirected to the specific page you were at.)
7) Now you can log out. (You will then have a small SQL Trace file with just the page of tracing you specified)

This is great when trying to examine the SQL Trace data as it reduces file size and wading through many queries. (The StartAction text does help when searching, but I like this technique even more. :happy )