Steps:
Use the Query Administration - Executing page to display all currently running queries and to monitor queries that are running for specified periods.
Step 1For instance, if the Query Administration - Executing page indicates that a simple query takes more than 10 minutes to complete, you conclude that there is a problem with the query or the application server and start to investigate.
Step 2If a query is running, you can perform an action by clicking one of the following buttons:
• Kill Selected Processes
Forces the selected query to stop running.
• Logging On
Enables logging for the selected query.
• Logging Off
Disables logging for the selected query.
• Enable
Enables the selected query to be run, previewed, or scheduled.
• Disable
Disables the selected query from being run, previewed, or scheduled.
Step 3You have successfully reviewed the Understanding How to Cancel Currently Running Queries topic.