SQL Server Performance

How to Analyze SQL Server Trace which is imported

Discussion in 'Performance Tuning for DBAs' started by sponguru_dba, May 3, 2007.

  1. sponguru_dba New Member

    Hi all

    I have a trace file which is imported from client site,I have to analyze that trace

    can some body your greate inputs to way of aproch to meet the requirments



    Thanks in Advance



    SreenivasaRao
    09342196319
    "If Iam Wrong suggest me Right"
  2. techbabu303 New Member

    Hi ,

    If you plannning to check the indexes , you can use the Index Tuning wizard and supply this trace file as input.

    Other options are to just open trace file and manally skim thorugh based on CPU and memory usage for long run queries and investigate further on them.

    Cheers
    Sat
  3. satya Moderator

    http://vyaskn.tripod.com/analyzing_profiler_output.htm
    http://articles.techrepublic.com.com/5100-6329-5054787.html
    http://www.sql-server-performance.com/query_analyzer_tips.asp
    http://www.sql-server-performance.com/index_tuning_wizard_tips.asp


    I;m sure Luis will addup more information here.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  4. sponguru_dba New Member

    Thanks a lot
    Techbabu303 & Satya

    SPONGURU
    "If Iam Wrong suggest me Right"
  5. MohammedU New Member

    YOu can also use Read80Trace.exe for trace files analsis....

    Description of the SQL Server Performance Analysis Utilities Read80Trace and OSTRESS
    http://support.microsoft.com/default.aspx?scid=kb;en-us;887057


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  6. SQLSolutions New Member

    Try SQL Trace Analyzer:
    http://www.lakesidesql.com/tadownload/traceanalyzersignup/trace_analyzer_signup.aspx

Share This Page