Anmelden
 
HomeLibraryDownloadsSupportWebcasts & EventsCommunityForenBlogs
Ressourcen für IT-Professionals >
> 
> 
Analyze SQL profiler trace file

Jawab Analyze SQL profiler trace file

  • Freitag, 15. März 2013 10:01
     
     
    Anmelden
    0
    I have generated a SQL profiler trace for a database during sequence of actions. How to get statistics from this generated  .trc file. 
     

Alle Antworten

  • Montag, 18. März 2013 06:09
     
     
    Anmelden
    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

     
  • Montag, 18. März 2013 06:40
    Moderator
     
     Beantwortet
    Anmelden
    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