92
Part I: Laying the Foundations
■ (^) Availability Groups: Lists the Availability Groups confi gured on this server. This
node will only appear if the AlwaysOn feature is enabled on the server instance.
The Management node contains several server-wide administration tools:
■ Policy Management: Creates and manages Policy-Based Management policies.
■ (^) Data Collection: Defi nes data collection points for SQL Server’s Management Data
Warehouse.
■ (^) Resource Governor: Controls Enterprise Edition’s CPU and Memory Resource
Governor.
■ (^) Extended Events: Set up and monitor Extended Events sessions.
■ Maintenance Plans: Create and manage Maintenance Plans.
■ (^) SQL Server Logs: SQL Server creates a new log with every restart of the service;
view them here.
■ (^) Database Mail: Confi gures and monitors Database Mail.
■ Distributed Transaction Coordinator: Manages DTC for transactions involving
multiple servers.
■ Legacy: Contains deprecated objects such as older database maintenance plans.
Integration Services Catalogs contains the SSISDB catalog, which contains the objects
needed to work with Integration Services (SSIS) projects.
■ (^) SSISDB: Stores objects needed for working with Integration Services such as proj-
ects, packages, parameters, environments, and operational history.
The fi nal node links to SQL Server Agent tools (if SQL Server Agent is running):
■ Jobs: Control SQL Server Agent Jobs.
■ (^) Job Activity Monitor: View Job Activity.
■ Alerts: Confi gure SQL Server Agent Alerts.
■ (^) Operators: Set up SQL Server Agent Operators.
■ Proxies: Manage SQL Server Agent external.
■ (^) Error Logs: View SQL Server Error Logs.
Because Management Studio and SQL Server are communicating as client and server, the two processes are
not always in sync. Changes on the server are often not immediately refl ected in Management Studio unless
Management Studio is refreshed, which is why nearly every tool has a Refresh icon, and Refresh is in nearly every
context menu.
c05 July 23, 2012 11:44 AM V1
c05.indd 92c05.indd 92 7/30/2012 4:14:46 PM7/30/2012 4:14:46 PM
http://www.it-ebooks.info