How can i know Query execution time?

[nmmure]

Hi,

In report preview mode, Under the Report tab we have report performance tab, there we can check the Run the database query & read the database records, using those commands we can check the performance statistics.

Are there any custom tools for checking DML & select query performance (Time & Cost).

Pls any one have idea. Please pass me the information

I’m using SQL server 2000 & Crystal XI.

Thanks
Mure

 

[synapsevampire]

You can use the trace facility in Profiler, whihc is a SQL Server tool found in the Query Amanyzer to accomplish this, try the TSQL By Duration to log queries running over X seconds.

You can get purdy much anything you need there.

-k