Chapter 12 DBMS-Specific Features

Resource Governor

Resource Governor, available in SQL Server 2008, lets you limit resource requests by workloads for CPU time and memory to optimize their allocation. PowerDesigner supports Resource Governor through the following objects:

• Workload groups – are containers for sets of similar session requests.
• Resource pools – represent the physical resources of the server.

Copyright (C) 2008. Sybase Inc. All rights reserved.