Toad for SQL Server 7.4 - Installation Guide

Kill Processes

To kill a running process

1. Select Tools | Monitor | Session Browser.

2. Right-click a running user process and select Kill Process.

Notes:

• Ensure that you understand the possible consequences before killing a process.

• You cannot kill running system processes.

• You cannot kill your own running process.

Related Topics

Session Browser

Resource Governor

Create and Alter Resource Pools

Resource Governor functionality is only available in SQL Server 2008 or later.

Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To create or alter a resource pool

1. Select Resource Governor from the Management node in the Object Explorer.

2. Select one of the following:
   • Click to create a resource pool.
   • Select a resource pool and click to alter it.

3. Review the following for additional information:

   Min CPU %	Select the minimum CPU percentage to use for resource pool requests if there are CPU conflicts.
   Max CPU %	Select the maximum CPU percentage to use for resource pool requests if there are CPU conflicts.
   Min Memory %	Select the minimum percentage of memory that is not shared with other resource pools.
   Max Memory %	Select the maximum percentage of memory to use for this resource pool.

Create and Alter Workloads

Resource Governor functionality is only available in SQL Server 2008 or later.

Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To create or alter a workload

1. Select Resource Governor from the Management node in the Object Explorer.

2. Right-click a resource pool and select View Details.

3. Select the Workloads tab.
4. Select one of the following:
   • Click to create a workload.
   • Select a workload and click to alter it.

5. Review the following for additional information:

   CPU time (sec)	Select the maximum amount of CPU time that can elapse for a request before generating an event.
   Grant time-out (sec)	Select the maximum amount of time to wait for an available memory grant.
   Group max requests	Enter the maximum number of requests in a workload group that can execute concurrently.
   Importance	Select the level of importance for this workload group.
   Memory grant %	Enter the maximum percentage that can be allocated from the resource pool for a request. Important: To avoid possible out-of-memory errors because large queries run separately if the percentage is greater than 50 percent, make sure you use a setting that is less than 50 percent.