Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Analyze SQL profiler trace file

Answered Analyze SQL profiler trace file

  • Friday, March 15, 2013 10:01 AM
     
     
    Sign In to Vote
    0
    I have generated a SQL profiler trace for a database during sequence of actions. How to get statistics from this generated  .trc file. 
     

All Replies

  • Monday, March 18, 2013 6:09 AM
     
     
    Sign In to Vote
    0
    What kind of statistics are you interested in? This may not be the right place for this question. Post your question in the T-SQL forum

    Please vote as helpful or mark as answer, if it helps
    Cheers, Raunak | t: @raunakjhawar | My Blog

     
  • Monday, March 18, 2013 6:40 AM
    Moderator
     
     Answered
    Sign In to Vote
    0
    Hi Deepthi Kalyan,

    Use SQL Server Profiler to view captured event data in a trace. SQL Server Profiler displays data based on defined trace properties. One way to analyze SQL Server data is to copy the data to another program, such as SQL Server or Database Engine Tuning Advisor. Database Engine Tuning Advisor can use a trace file that contains SQL batch and remote procedure call (RPC) events if the Text data column is included in the trace. To make sure that the correct events and columns are captured for use with Database Engine Tuning Advisor, use the predefined Tuning template that is supplied with SQL Server Profiler.  Details please see: http://msdn.microsoft.com/en-us/library/ms175848.aspx

    Thanks,
    Eileen

    Eileen Zhao
    TechNet Community Support