Microsoft SQL Server 2008 R2 810-08230 Manuel D’Utilisation
Codes de produits
810-08230
96
CHAPTER 5
Consolidation and Monitoring
Resource utilization for each managed instance of SQL Server is presented in the list view
located at the top of the Utility Explorer Content pane . Health state icons appear to the right
of each managed instance and provide summary status for each instance of SQL Server based
on the utilization category . Three icons are used to indicate the health of each managed
instance of SQL Server . A green check mark indicates that an instance is well utilized and does
not violate any policies . A red arrow indicates that an instance is overutilized, and a green ar-
row indicates underutilization . The lower half of the dashboard contains tabs for CPU utiliza-
tion, storage utilization, policy details, and property details for each managed instance .
of each managed instance and provide summary status for each instance of SQL Server based
on the utilization category . Three icons are used to indicate the health of each managed
instance of SQL Server . A green check mark indicates that an instance is well utilized and does
not violate any policies . A red arrow indicates that an instance is overutilized, and a green ar-
row indicates underutilization . The lower half of the dashboard contains tabs for CPU utiliza-
tion, storage utilization, policy details, and property details for each managed instance .
In Figure 5-7, the instance CPU, computer CPU, file space, and volume space columns for
SQL2K8R2-01\INSTANCE01 and SQL2K8R2-01\INSTANCE05 are all underutilized . In addi-
tion, the following other elements are underutilized: the Instance CPU for SQL2K8R2-03\
INSTANCE03, Computer CPU for SQL2K8R2-01\INSTANCE02, SQL2K8R2-01\INSTANCE03,
SQL2K8R2-01\INSTANCE04 and SQL2K8R2-01\INSTANCE05, File Space for SQL2K8R2-02\IN-
STANCE03 and Volume Space for SQL2K8R2-01\INSTANCE02, SQL2K8R2-01\INSTANCE03, and
SQL2K8R2-01\INSTANCE04 . The volume space for SQL2K8R2-02, SQL2K8R2-02\INSTANCE02,
SQL2K8R2-03, SQL2K8R2-03\INSTANCE02, SQL2K8R2-03\INSTANCE03, and SQL2K8R2-03\
INSTANCE04 are all overutilized, and the remainder of managed instances are well utilized .
tion, the following other elements are underutilized: the Instance CPU for SQL2K8R2-03\
INSTANCE03, Computer CPU for SQL2K8R2-01\INSTANCE02, SQL2K8R2-01\INSTANCE03,
SQL2K8R2-01\INSTANCE04 and SQL2K8R2-01\INSTANCE05, File Space for SQL2K8R2-02\IN-
STANCE03 and Volume Space for SQL2K8R2-01\INSTANCE02, SQL2K8R2-01\INSTANCE03, and
SQL2K8R2-01\INSTANCE04 . The volume space for SQL2K8R2-02, SQL2K8R2-02\INSTANCE02,
SQL2K8R2-03, SQL2K8R2-03\INSTANCE02, SQL2K8R2-03\INSTANCE03, and SQL2K8R2-03\
INSTANCE04 are all overutilized, and the remainder of managed instances are well utilized .
The Managed Instances list view columns and utilization tabs are discussed in more detail
in the next sections .
The Managed Instances List View Columns
The health status of each managed instance of SQL Server in the Managed Instances list view
is analyzed against four types of utilization and the current policy in place for each:
is analyzed against four types of utilization and the current policy in place for each:
■
Instance CPU
This column indicates processor utilization of the managed instance .
The health state is determined by the global CPU Utilization For All Managed Instances
Of SQL Server policy, which is predetermined for all managed instances of SQL Server .
However, by clicking on the Policy Tab in the bottom half of the view, DBAs can over-
ride this global policy to configure overutilization and underutilization policies for
a single instance . The CPU Utilization tab shows the CPU utilization history for the
selected managed instance of SQL Server .
Of SQL Server policy, which is predetermined for all managed instances of SQL Server .
However, by clicking on the Policy Tab in the bottom half of the view, DBAs can over-
ride this global policy to configure overutilization and underutilization policies for
a single instance . The CPU Utilization tab shows the CPU utilization history for the
selected managed instance of SQL Server .
■
Computer CPU
This column communicates computer processor utilization where
the managed instance resides . Health is based on the settings of two policies: the CPU
utilization policy in place for the computer and the configuration setting for the Vola-
tile Resource Evaluation policy . The CPU Utilization tab shows the processor utilization
history for a managed instance of SQL Server .
utilization policy in place for the computer and the configuration setting for the Vola-
tile Resource Evaluation policy . The CPU Utilization tab shows the processor utilization
history for a managed instance of SQL Server .
■
File Space
The File Space column summarizes file space utilization for all of the
databases belonging to a selected instance of SQL Server . The health state for this
parameter is determined by global or local file space utilization policies. Because there
are many database associated with a managed instance of SQL server, the health state
is reported as overutilized if only one database is overutilized . The Storage Utilization
tab shows health state information on all other database files.
parameter is determined by global or local file space utilization policies. Because there
are many database associated with a managed instance of SQL server, the health state
is reported as overutilized if only one database is overutilized . The Storage Utilization
tab shows health state information on all other database files.