Post reply

Server Trace and Client Statistics

  • 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

  • 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

     

     

  • 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?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply