Microsoft SQL Server 2008 R2 Specifiche Scaricare il pdf (Pagina 26)

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

1 2 ... 21 22 23 24 25 26 27 28 29 30 31 ... 235 236

Nessun commento

Microsoft SQL Server 2008 R2 Specifiche Pagina 26