Real-Time Query Duration Display While Executing in TOAD for SQL Server

Toad for SQL Server Idea Pond
1

I frequently run long and complex queries in TOAD for SQL Server. Currently, TOAD only displays the execution duration after the query completes. It would be extremely helpful to have a real-time display of query duration while the code is executing.

This feature could be implemented in several ways:

  • A live timer in the status bar or output pane that starts when the query begins and updates every second.
  • An optional setting to enable/disable real-time duration tracking for performance-sensitive environments.
  • Integration with session monitoring to show elapsed time alongside session ID and query status.

Benefits:

  • Improves visibility into query performance.
  • Helps developers and DBAs identify long-running queries early.
  • Enhances usability and aligns with features available in other tools like SSMS.

Please consider adding this feature in a future release. It would be a valuable enhancement for many users who rely on TOAD for daily database development and performance tuning.

Thank you!

2

Thank you for your detailed suggestion and for highlighting the potential value this enhancement could bring to our users. We have logged this request in our product backlog under ID TSS-I-9, and it will be reviewed for consideration in future releases of Toad for SQL Server.

We appreciate your input and the time you invested in sharing this idea with us.

3

Hi,

Toad does have a live timer at the very bottom of the GUI. It is below the Result Set that shows query duration. I am not sure if there is an option setting that is affecting your ability this or if you are on a different version. I am on 8.1.

image