Hello Anybody !

I want to get the execution time of a query, I mean I will run the one sql statement like this " SELECT * FROM tblname WHERE field1 = '009' and then I want to get from my program execution time of this query. I think I just keep the sys time before run it and compare with sys time when finished it. But I don't like this one, So, can I get the execution time from sql server by running their sys s-procedure or something like.

 Thanks.

Hi,

You can get your querry execution plan by addin following this from SqlServer Management Studio Meues.

Go to Querry menu and add following things.

1.Display Estimated Execution Plan

2.Include Actual Execution Plan.

From this technique you can also optimise your queryy,like creating nonclustered indexes,statistics and database partitioning etc.

Mark answered if this post help you.

Thanks for your help. But this one I already, I mean I want to get from my program of executing time of query.

My logic is like this. some thing like ths search engine. I would to search the inventory part id in my database, If found, I want to display the search time for it to the user. So I need to get the execution time from my program.

Thanks.

 " /* Read the initial time. */
    DateTime startTime = DateTime.Now;
    Console.WriteLine(startTime);

    /* YOUR QUERY. */
    

    /* Read the end time. */
    DateTime stopTime = DateTime.Now;
    Console.WriteLine(stopTime);

    /* Compute the duration between the initial and the end time. */
    TimeSpan duration = stopTime - startTime;
    Console.WriteLine(duration);

The output of this code looks something like this:

    4/17/2005 4:12:30 PM
    4/17/2005 4:12:31 PM
    00:00:01.7224768"

Yes junkie... Thanks a lot for your answer.