# Scenarios for resource control


+ Database consolidation
  + Combine multiple small and medium-sized applications from different systems into a single TiDB cluster
  + Combine all test environments into a single TiDB cluster
  + Put different workloads into separate resource groups in one system
+ Temporarily limit the resource consumption of a SQL statement
+ Mixed workloads, for example
  + OLTP and batch processing happens at the same time
  + OLTP and analytical query happens at the same time


-----------------------------------------------------------------
With resource control, you can:
+ Combine multiple small and medium-sized applications from different systems into a single TiDB cluster. When the workload of an application grows larger, it does not affect the normal operation of other applications. When the system workload is low, busy applications can still be allocated the required system resources even if they exceed the set quotas, so as to achieve the maximum utilization of resources.
+ Choose to combine all test environments into a single TiDB cluster, or group the batch tasks that consume more resources into a single resource group. It can improve hardware utilization and reduce operating costs while ensuring that critical applications can always get the necessary resources.
+ When there are mixed workloads in a system, you can put different workloads into separate resource groups. By using the resource control feature, you can ensure that the response time of transactional applications is not affected by data analysis or batch applications.
+ When the cluster encounters an unexpected SQL performance issue, you can use SQL bindings along with resource groups to temporarily limit the resource consumption of a SQL statement.
In addition, the rational use of the resource control feature can reduce the number of clusters, ease the difficulty of operation and maintenance, and save management costs.