Specifications

SQL Server 2008 R2 Enhancements for DBAs CHAPTER 1 5
the total cost of ownership of their database environment. The new SQL Server Utility
dashboards also assist with consolidation efforts. Figure 1-1 illustrates SQL Server Utility
dashboard and viewpoints for providing superior insight into resource utilization and
policy violations.
FIGURE 1-1 Monitoring resource utilization with the SQL Server Utility dashboard and viewpoints
■
Consolidation management Organizations can maximize their investments by
consolidating SQL Server resources onto fewer systems. DBAs, in turn, can bolster their
consolidation efforts through their use of SQL Server Utility dashboards and view-
points, which easily identify underutilized and overutilized SQL Server resources across
the SQL Server Utility. As illustrated in Figure 1-2, dashboards and viewpoints make it
simple for DBAs to realize consolidation opportunities, start the process toward elimi-
nating underutilization, and resolve overutilization issues to create healthier, pristine
environments.