Post reply

Estimate the rbutime of a query

  • January 27, 2005 at 3:48 am

    #162280

    Hi,

    I wondering if there is a way to estimate on the fly how long a query will take to execute ...

    I'm not looking for a perfect estimation but just for an info !

    Thanks!

  • January 27, 2005 at 4:29 am

    #539304

    I use this.  There are probably better ways:

    set nocount on

    declare @testtime as varchar(30)

    set @Testtime = convert(varchar(30), getdate(), 126)

    print @testtime

    === > Run query here

    set @Testtime = convert(varchar(30), getdate(), 126)

    print @testtime

     

  • January 27, 2005 at 4:54 am

    #539306

    Thanks !

    But I would like to estimate the time before executiong the query ...

  • January 28, 2005 at 7:10 am

    #539522

    I don't have a clue how you can do that other then a crystal ball.  Another method besides the first one I mentioned would be:

    From Query Analyzer click on "query" and select:

    Show Execution Plan

    Show Server Trace

    Show Client Statistics

    The statistics will be in tabs under the results grid.  I don't know enough about them to really help analyze the results.

     

     

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

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