Click to Rate and Give Feedback
MSDN
MSDN Library
SQL Server
SQL Server 2008
Database Engine
Technical Reference
 sys.resource_governor_resource_pool...

  Switch on low bandwidth view
Community Content
In this section
Statistics Annotations (0)
SQL Server 2008 Books Online (June 2009)
sys.resource_governor_resource_pools (Transact-SQL)

Returns the stored resource pool configuration. Each row of the view determines the configuration of a pool.

Column name Data type Description

pool_id

int

Unique ID of the resource pool. Is not nullable.

name

sysname

Name of the resource pool. Is not nullable.

min_cpu_percent

int

Guaranteed average CPU bandwidth for all requests in the resource pool when there is CPU contention. Is not nullable.

max_cpu_percent

int

Maximum average CPU bandwidth allowed for all requests in the resource pool when there is CPU contention. Is not nullable.

min_memory_percent

int

Guaranteed amount of memory for all requests in the resource pool. This is not shared with other resource pools. Is not nullable.

max_memory_percent

int

Percentage of total server memory that can be used by requests in this resource pool. Is not nullable. The effective maximum depends on the pool minimums. For example, max_memory_percent can be set to 100, but the effective maximum is lower.

The catalog view displays the stored metadata. To see the in-memory configuration, use the corresponding dynamic management view.

Requires VIEW ANY DEFINITION permission to view contents, requires CONTROL SERVER permission to change contents.

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker