Specifications

SQL Server 2008 R2 Enhancements for DBAs CHAPTER 1 7
environment. This can be done at scale, with information on resource utilization throughout the
managed database environment, as a result of centralized visibility. In addition, a data-tier devel-
oper is building a data-tier application with Visual Studio 2010; the newly created DAC package
will be deployed to a managed instance of SQL Server through the Utility Control Point.
Utility dashboard to
monitor health state
Upload collection
data set
Managed instance
Managed instance
Utility Control Point
UMDW msdb
Upload collection
data set
Upload collection
data set
Managed instance
DBA
SSMS
Delivery DAC package onto
managed instance
Developer
Visual Studio
2010
DAC
FIGURE 1-3 The SQL Server Utility, including a UPC, managed instances, and a DAC