Problems that Resource Manager solves
Resource Manager is not without its own problems, but it does solve others' problems and is absolutely worth investigating. The use of Resource Manager is a strategic decision and belongs to a global design system where we put one instance of a database on one server. We won't combine multiple instances on a server. This is called instance consolidation. From the clients, we should address service names and not instance names to connect to the database. If we follow these rules, we can make the best use of Resource Manager. Resource Manager can solve the following issues:
Guarantee sessions a minimum amount of CPU resources
Distribute load among groups of users or processes
Control the degree of parallelism for sessions
Control the number of active sessions in a session pool
Free the system from unwanted processes that consume more than expected resources (runaway processes)
Prevent unwanted long-running operations from being started at all
Control session...
