Specifications

6 CHAPTER 1 SQL Server 2008 R2 Editions and Enhancements
FIGURE 1-2 Identifying consolidation opportunities with the SQL Server Utility dashboard and
viewpoints
■
Customization of utilization thresholds and policies DBAs can customize the
utilization threshold and policies for managed instances of SQL Server and deployed
data-tier applications to suit the needs of their environments. For example, DBAs can
specify the CPU utilization policies, le space utilization policies, computer CPU utilization
policies, and storage volume utilization policies for all managed instances of SQL Server.
Furthermore, they can customize the global utilization policies for data-tier applications.
For example, a DBA can specify the CPU utilization policies and le space utilization poli-
cies for all data-tier applications. The default policy setting for overutilization is 70 per-
cent, whereas underutilization is set to 0 percent. By customizing the utilization threshold
policies, DBAs can maintain higher service levels for their SQL Server environments.
Figure 1-3 illustrates the SQL Server Utility. In this gure, a Utility Control Point has been
deployed and is collecting health state and resource utilization data from managed instances of
SQL Server and deployed data-tier applications. A DBA is making use of the SQL Server Utility
dashboards and viewpoints included in SSMS to proactively and efciently manage the database