Estimated time to complete the query.

Question

Estimated time to complete the query.

sam king

SSC-Addicted

Points: 479
More actions
August 6, 2014 at 9:24 am

#294028

Hi friends,
I am running an update query.
It is taking long time. To find the estimated completion time i checked sys.dm_exec_request or sys.dm_exec_session or sp_who2 but there is no clue. It is showing as zero.
can any one help on this please.
Regards,
SAM
Regards,
SAM
***Share your knowledge.It’s a way to achieve immortality----Dalai Lama***

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

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

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 1

samking (8/6/2014)
Hi friends,
I am running an update query.
It is taking long time. To find the estimated completion time i checked sys.dm_exec_request or sys.dm_exec_session or sp_who2 but there is no clue. It is showing as zero.
can any one help on this please.
Regards,
SAM

Post the query, please. There's a typcial problem that many folks write into their update queries without knowing about it. To summarize the problem, if the UPDATE contains a JOIN, the target table MUST absolutely appear in the FROM clause. Using tablename.columnname is NOT sufficient and that form of UPDATE never appears in Books Online.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

There's no estimated completion for queries, that's for things like backups.

No way to tell how long the query will take other than to run it and see.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

sam king SSC-Addicted Points: 479 More actions · Answer 3

Hi GailMosnter..

Thanks for the reply. After surfing google i came to know that we can find the estimation time for any update insert or other queries.

We can know the estimated time only for backup and restore.

Regards,

SAM

Regards,
SAM
***Share your knowledge.It’s a way to achieve immortality----Dalai Lama***