Tuning in Sql Server 2000 1

[cmmrfrds]

What is a simple way to trace the performance of queries. I want to check the duration of the queries and how many physical reads, then print out the results when I want to save the results. The purpose is to get some statistics before I add indexes to some of the tables. Also, to check the performance of stored procedures. Then, later to check some update queries.

If somebody can tell me the steps to take, I will appreciate it. I am familiar with Query Analyzer and Enterprise Manager, but I am not sure how to make use of Sql Profiler.

Thank you,
Jerry

 

[tlbroadbent]

In Query Analyzer, Select Query | Current Connection Properties... from the main menu. Set the options Statistics Time and Statistics IO on. Then execute your query. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[cmmrfrds]

Thanks Terry, that is exactly what I was looking for.

Jerry