Specifications

Using the Managed Instances Viewpoint CHAPTER 5 97
■
Volume Space Volume space utilization is summarized in this column for volumes
with databases belonging to each managed instance. The health of this parameter
is determined by the global or local storage volume utilization policies for managed
instances of SQL Server. As with le space reports, the health of a storage volume asso-
ciated with a managed instance of SQL Server that is overutilized is reported with a red
up arrow, and underutilization is reported with a green arrow. The Storage Utilization
tab shows additional health information and history for volumes.
■
Policy Type The nal column in the list view species the type of policy applied to
the managed instance of SQL Server. Policy type results are reported as either Global
or Override, with Global meaning that default policies are in use, and Override mean-
ing that custom policies are in use.
DBAs can appreciate the value of the information each list view column holds. But, in the
case of the Managed Instances view, DBAs can gain an even greater appreciation by also ac-
cessing the Managed Instances viewpoint tabs to better understand their present infrastruc-
ture and to better prepare for a successful consolidation.
The Managed Instances Detail Tabs
The Managed Instances viewpoint includes tabs for additional viewing. The tabs are located
at the bottom of the viewpoint and consist of
■
CPU Utilization The CPU Utilization tab, illustrated earlier in Figure 5-7, displays
historical information of CPU utilization for a selected managed instance of SQL Server
according 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 these 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
Two linear graphs are presented next to each other. The rst graph shows CPU utiliza-
tion based on the managed instance of the SQL Server, and the second graph displays
data based on the computer associated with the managed instance.
■
Storage Utilization The next tab displays storage utilization for a selected man-
aged instance of SQL Server, as depicted in Figure 5-8. Data is grouped by either
database or volume. When the Database option button is selected, storage utilization
is displayed for each database, legroup, or a specic database le, which is based on
the node selected in the tree view. If the Volume option button is selected, storage uti-
lization history is displayed according to le space used by all data les and all log les
located on the storage volume. The tree view also can be expanded to present storage
utilization information and history for each volume and database le associated with a
volume.