The MS SQL Resource Pool Stats attribute group
provides statistics associated with resource pools. Note: This attribute group is not supported on the SQL Server
2005 and 2008 Express® Edition.
Active Memory™ Grant Amount The total
amount of granted memory in megabytes in the resource pool. The
format is an integer. The following values are also valid:
| External value |
Internal value |
Description |
|---|
| Not Collected |
-1 |
The value could not be collected. |
Active
Memory Grants Count The count
of memory grants that are assigned to pool workers. The format
is an integer. The following values are also valid:
| External value |
Internal value |
Description |
|---|
| Not Collected |
-1 |
The value could not be collected. |
Cache Memory Target The current memory target for cache memory
in megabytes. The format is an integer. The following values
are also valid:
| External value |
Internal value |
Description |
|---|
| Not Collected |
-1 |
The value could not be collected. |
Compile Memory Target The current memory target for compile memory
in megabytes. The format is an integer. The following values
are also valid:
| External value |
Internal value |
Description |
|---|
| Not Collected |
-1 |
The value could not be collected. |
CPU Control Effect Percent The effect of the resource governor on the
resource pool calculated as (CPU Usage Percent)/(CPU Usage Percent
without RG). The format is an integer. The following values are
also valid:
| External value |
Internal value |
Description |
|---|
| Not Collected |
-1 |
The value could not be collected. |
CPU Usage Percent The system CPU Usage by all requests in the
specified instance of the performance object. The format is an
integer. The following values are also valid:
| External value |
Internal value |
Description |
|---|
| Not Collected |
-1 |
The value could not be collected. |
CPU Usage Target Percent The target value of CPU Usage Percent for the
resource pool based on the configuration settings and the system load. The
format is an integer. The following values are also valid:
| External value |
Internal value |
Description |
|---|
| Not Collected |
-1 |
The value could not be collected. |
Host Name The
name of the computer on which the SQL Server is running. The
value format is an alphanumeric string with a maximum of 64 characters,
for example, Voyager. This attribute is not available for use in situations
or for historical data collection.
Hub Timestamp The time when data is inserted at the hub.
Max Memory The
maximum amount of memory in megabytes the resource pool can have based
on the settings and the server state. The format is an integer.
The following values are also valid:
| External value |
Internal value |
Description |
|---|
| Not Collected |
-1 |
The value could not be collected. |
Memory Grant Timeouts Per Sec The number of query memory grant timeouts per
second occurring in the resource pool. The format is an integer.
The following values are also valid:
| External value |
Internal value |
Description |
|---|
| Not Collected |
-1 |
The value could not be collected. |
Memory Grants Per Sec The number of query memory grants per second
occurring in the resource pool. The format is an integer. The
following values are also valid:
| External value |
Internal value |
Description |
|---|
| Not Collected |
-1 |
The value could not be collected. |
Originnode The
key to this table of the format serverid:hostname:MSS.
Pending Memory Grants Count The number of queries waiting for memory grants
in the resource pool. The format is an integer. The following
values are also valid:
| External value |
Internal value |
Description |
|---|
| Not Collected |
-1 |
The value could not be collected. |
Query Exec Memory Target The current memory target for query execution
in megabytes. The format is an integer. The following values
are also valid:
| External value |
Internal value |
Description |
|---|
| Not Collected |
-1 |
The value could not be collected. |
Resource Pool Name The resource governor resource pool name. The
following values are valid:
| External value |
Internal value |
Description |
|---|
| No Data |
nodata |
The value could not be collected. |
Sample Timestamp The time when data is collected.
Server The
name of the SQL Server.
Target Memory The
target amount of memory in megabytes the resource pool tries to attain
based on the settings and the server state. The format is an
integer. The following values are also valid:
| External value |
Internal value |
Description |
|---|
| Not Collected |
-1 |
The value could not be collected. |
Used Memory The
used amount of memory in megabytes in the resource pool. The
format is an integer. The following values are also valid:
| External value |
Internal value |
Description |
|---|
| Not Collected |
-1 |
The value could not be collected. |