Running query time estimate

• suhas.wadadekar

  Ten Centuries

  Points: 1219

  More actions

  March 11, 2008 at 11:30 am

  #379167

  Hi,

  Is there a way is SQL Server 2005 to estimate the remaining time for a query that is currently getting executed?

  Thanks,

  Suhas.

• Grant Fritchey

  SSC Guru

  Points: 398909

  More actions

  March 11, 2008 at 12:12 pm

  #788209

  Nope. Not through anything available in the system for your basic queries. There is a way to output status on restores & backups & such.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning