SQL Server Performance Forum – Threads Archive

Estimate Query RunTime

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!

---

Query execution plan from Query analyzer or PROFILER is best bet to get accurate information. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

My query is dynamic … That’s mean I can have one day 100 INSERTs and the day after 1000 INSERT + 250 UPDATES etc … With this inforation I would like to say : "Ok … it will take at least : 2 seconds …"

---

Then to get information about the differences, you can produce an estimated showplan, but it won’t necessarily return actual time figures. Instead, the showplan displays the query optimizer’s time estimate from a reference computer. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

]]>