10.9 Using the Execution Monitor

The Execution Monitor allows the user to see information (including SPID) on queries  that are being run, including execution status, time, warning messages, total number of processes, number of terminated processes and more. It monitors the status of all the queries issued in Query Analyzer, Query Builder and Table Data Editor. The monitor has been designed in order to notify a user about long running queries so they can be canceled; and/or it can terminate those queries automatically, as those queries may unnecessarily consume valuable server resources.

In the application options, the File->Options:General:Excution Monitor section sets options for the Execution Monitor such as query warning time, query stop time and snooze time. The user will be notified when a query runs beyond the warning time. Extending its running time by altering the snooze time will automatically stop the query once it reaches its stop time

The monitor dialog opens automatically to warn the user when a query runs beyond the warning time. The user will be able to cancel this query, snooze it, let it run till it is stopped automatically, and clear the query information from the monitor once it’s stopped

The user can also open the Execution Monitor from the Tools menu and see all of the queries currently running. The Execution Monitor displays information about the queries including SPID.

By default, the Execution Monitor is disabled for queries running from the Table Editor as the table editing already handles long transactions. The user can enable it in the application options as File->Options->General->Execution Monitor: "Enable Execution Monitor for Table Data Editor".