Managing the Core Database Engine - Microsoft SQL Server 2008 R2 Administration - page 125

In order to use SQL Server Agent service, the users must be a member of one or more
of msdb fixed database roles: SQLAgentUserRole , SQLAgentReaderRole , or
SQLAgentOperatorRole . These additional roles are stored in the msdb system database.
Users require membership in these roles and it must be granted explicitly. Users who are
members of the sysadmin fixed server role have full access to SQL Server Agent, and do
not need to be a member of these fixed database roles to use SQL Server Agent. If a user
is not a member of one of these database roles, or of the sysadmin role, the SQL Server
Agent node is not available to them when they connect to SQL Server by using SQL Server
Management Studio.
See Also
For more information on SQL Server agent service refer to the Designing automated
administration practices recipe mentioned in Chapter 2 , Administration of Core Database Engine .
Multiserver Management Using Utility
Explorer
SQL Server 2008 R2 improves the ability to manage multiple servers centrally with UCP.
The UCP collects configuration and performance information that includes database file
space utilization, CPU utilization, and storage volume utilization from each enrolled instance.
Using Utility Explorer helps you to troubleshoot the resource health issues identified by SQL
Server UCP. The issues might include mitigating over-utilized CPU on a single instance or
multiple instances.
UCP also helps in reporting troubleshooting information using SQL Server Utility on issues
that might include resolving a failed operation to enroll an instance of SQL Server with a UCP,
troubleshooting failed data collection resulting in gray icons in the managed instance list view
on a UCP, mitigating performance bottlenecks, or resolving resource health issues.
In order to manage multiple instances efficiently, there are certain settings available
within the Utility Explorer tool. In this recipe, we will focus on how to manage multiple
instances using Utility Explorer by setting global policies for data-tier applications (DAC),
and managed instances.
Getting ready
The UCP and all managed instances of SQL Server must satisfy the following prerequisites:
F UCP SQL Server instance version must be SQL Server 2008 SP2 [10.00.4000.00]
or higher
F The managed instances must be a database engine only and the edition must be
Datacenter or Enterprise on a production environment