Specifications

102 CHAPTER 5 Consolidation and Monitoring
The Data-Tier Application List View
The columns presenting the state of health for each deployed data-tier application in the
data-tier application list view include
■
Application CPU This column displays the health state utilization of the processor
for the deployed data-tier application. The health state is determined by the CPU uti-
lization policy for deployed data-tier applications. The CPU Utilization tab shows CPU
utilization history for the selected deployed data-tier application.
■
Computer CPU This column communicates computer processor utilization for
deployed data-tier applications. The CPU Utilization tab shows the processor utilization
history for the deployed data-tier application.
■
File Space The File Space column summarizes le space utilization for each deployed
data-tier application. The health state for this parameter is determined by global or
local le space utilization policies. The Storage Utilization tab shows health state infor-
mation on all other database les.
■
Volume Space Volume space utilization is summarized in this column for volumes with
databases belonging to each deployed data-tier application. The health of this param-
eter is determined by the global or local Storage Volume utilization policies for deployed
data-tier application of SQL Server. Similar to File Space reports, the health of a storage
volume associated with a deployed data-tier application of SQL Server that is overutilized
is reported with a red arrow, and underutilization is reported with a green arrow. The
Storage Utilization tab shows additional health information and history for volumes.
■
Policy Type This column in the list view species the type of policy applied to a
deployed data-tier application of SQL Server. Policy Type results are reported as either
Global or Override. Global indicates that default policies are in use, and Override indi-
cates that custom policies are in use.
■
Instance Name The nal column in the list view species the name of the SQL
Server instance to which the data-tier application has been deployed.
The Data-Tier Application Tabs
The Data-Tier Applications viewpoint includes tabs for additional viewing. The tabs are lo-
cated at the bottom of the viewpoint and consist of
■
CPU Utilization The CPU Utilization tab, illustrated in Figure 5-11, displays historical
information on CPU utilization for a selected deployed data-tier application accord-
ing to the interval specied on the left side of the display area. DBAs can change the
display intervals for the graphs by selecting one of the following options:
●
1 Day Displays data in 15-minute intervals
●
1 Week Displays data in one-day intervals
●
1 Month Displays data in one-week intervals
●
1 Year Displays data in one-month intervals