Estimate the rbutime of a query

• xiii29

  Say Hey Kid

  Points: 695

  More actions

  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!

• Tyson L. Price

  Mr or Mrs. 500

  Points: 589

  More actions

  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

   

• xiii29

  Say Hey Kid

  Points: 695

  More actions

  January 27, 2005 at 4:54 am

  #539306

  Thanks !

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

• Tyson L. Price

  Mr or Mrs. 500

  Points: 589

  More actions

  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.