O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Modifying Your Resource Governor Configuration

You can modify settings for resource pools or workload groups in SQL Server Management Studio via the Resource Governor Properties page, as shown previously in Figure 37.4. You simply make the changes desired (for example, a Resource Pool Maximum CPU% or Workload Group Importance) and click OK to save the changes.

Alternatively, you can modify the resource pool using the ALTER RESOURCE POOL command. With this command, you can modify the minimum and maximum CPU and memory percentages for a resource pool. The syntax is as follows:

ALTER RESOURCE POOL { pool_name | "default" }[WITH          ( [ MIN_CPU_PERCENT = value ]     [ [ , ] MAX_CPU_PERCENT = value ]     [ [ , ] ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required