General
- Execution Monitor: Added Execution Monitor that monitors 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 he/she can cancel them; 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 as query warning time, query stop time and snooze time. The user will be notified when a query runs beyond the warning time, he/she can extend its running time by the snooze time, and the query will be stopped automatically once it reaches its stop time.
- The monitor dialog opens automatically to warn the user when some query runs beyond the warning time. The user will be able to cancel this query, snooze it, let it run till it's 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 displayes 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".
|
|