Server Trace and Client Statistics

• Beulah Kingsly

  SSCrazy

  Points: 2246

  More actions

  July 30, 2004 at 4:52 am

  #108761

  Hi,

  Can anyone explain about the "Show Server Trace" and "Show client Statistics" options in Query analyzer? Can you explain how we can use them to decide on the Performance of a Query?

  Thanks and Regards,

  Beulah Kingsly

• August 2, 2004 at 8:00 am

  This was removed by the editor as SPAM

• mnandy

  Valued Member

  Points: 55

  More actions

  August 2, 2004 at 4:31 pm

  #517343

  Both these options , when turned on displays information (only pertaining to the current SQL being executed in query analyzer).

  Server Trace - will display info for SQL:StmtCompleted and SP:StmtCompleted event classes. Same as profiler - diff is that only for the current SQL.

  Client Statistics- amount of work being performed to process the query. The VALUE column - results for the most recently run batch

  AVERAGE column - cumulative figure since the option was set to ON.

  Hope this helps

   

   

• Beulah Kingsly

  SSCrazy

  Points: 2246

  More actions

  August 2, 2004 at 9:54 pm

  #517361

  I did see the output of those options. But, I just want to know how they can help me in deciding in the performance of a Query. since, the values differ everytime for the same query, how do I know if Query2(improved form of Query1) is better than Query1?