Microsoft – SQL Server – Profiler – Trace Analyzer – ClearTrace

Microsoft – SQL Server – Profiler – Trace Analyzer – ClearTrace

Reviewing Microsoft SQL Server – Profiler – Trace Files is something a DBA has to occasionally do; especially when trying to address database performance issues.

One of the tools, I and a co-worker have started using is “ScaleSQL Consulting, LLC’s ClearTrace tool.

It is relatively straight forward and easy to use.

Where can we get it from:
http://www.scalesql.com/cleartrace/

What makes it special:

  1. It normalizes the SQL Statements – It replaces the actual values in query parameters with place holders.  By doing so, it is able to better reflect and categorize\group related queries
  2. It allows for simple filtering — one can filter per statement type, statements\objects,  Application, Host, or Login
  3. Data can be aggregated by CPU \ IO \ Duration

Installation:

The program does not need to be installed.  Once downloaded, just extract the compressed\zip file unto a directory of your choosing.

Processing:

Configuration:

The Application uses a MS SQL Server Instance to process the TraceFile. So the first of business is to specify the SQL Server particulars; currently the server and database name.

To do so:

  1. Launch the Application
  2. Click on the menu items (Tools \ Options)

Import the Files:

  1. Access the “Import Trace Files” tab
  2. In the “Trace Files” group box
    1. In the “First File” entry field, select the “Browse” button and indicate the file’s location
  3. If the “Import Files” button is not visible”, make sure that you have followed the steps detailed earlier in the “Configuration” section
  4. Click on the “Import Files” button
  5. As the file is imported, the status of the processing is indicated in the “Import Status” tab

Monitor the Import:

  1. As the file is imported, the status of the processing is indicated in the “Import Status” tab

Analyze the Import:

  1. Access the “Query the Imported files” tab, to analyze \ review the metrics


4 thoughts on “Microsoft – SQL Server – Profiler – Trace Analyzer – ClearTrace

  1. Can you tell me what is the ‘#’ in ClearTrace 2008 tools, which generate report in terms of item,#,cpu, avgcpu etc. in the ‘#’ column there is some numbers.i donot understand, what exactly it is. send me directly to my mailid.
    Thanks in Advance
    Shaheb

    • Shabeb – As we already spoke offline, I am adding this comment for others. The # column indicates the number of occurences of this particular item \ SQL signature.

    • Leslie:

      Thanks, per your feedback.

      And, no I have yet to look @ SQLTraceAnalyzer. It appears to be a good tool.

      Happy mileage if you choose to go with it. Please let me know how well it works?

      All the best,

      Daniel

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s