SQL Server Utility Features and Tasks
Applies To: SQL Server 2016
SQL Server customers have a requirement to manage their SQL Server environment as a whole, addressed in this release through the concept of application and multiserver management in the SQL Server Utility.
The SQL Server Utility models an organization’s SQL Server-related entities in a unified view. Utility Explorer and SQL Server Utility viewpoints in SQL Server Management Studio (SSMS) provide administrators a holistic view of SQL Server resource health through an instance of SQL Server that serves as a utility control point (UCP). The combination of summary and detailed data presented in the UCP for both underutilization and overutilization policies, and for a variety of key parameters, enables resource consolidation opportunities and resource overutilization to be identified with ease. Health policies are configurable, and can be adjusted to change either upper or lower resource utilization thresholds. You can change global monitoring policies, or configure individual monitoring policies for each entity managed in the SQL Server Utility.
The typical user scenario begins with creation of a utility control point which establishes the central reasoning point for the SQL Server Utility. The UCP provides a consolidated view of resource health collected from managed instances of SQL Server in the SQL Server Utility. After the UCP is created, you enroll instances of SQL Server into the SQL Server Utility so that they can be managed by the UCP.
Each instance of SQL Server and data-tier application managed by the SQL Server Utility can be monitored based on global policy definitions or based on individual policy definitions.
Use the following topics to get started with SQL Server utility.
Describes considerations to configure a server to run utility and non-utility collection sets on the same instance of SQL Server.
Describes how to create a SQL Server utility control point.
Describes how to connect to a SQL Server Utility.
Describes how to enroll an instance of SQL Server with a Utility Control Point.
Describes how to use Utility Explorer to manage the SQL Server utility.
Describes how to monitor instances of SQL Server in the SQL Server Utility.
Describes how to view resource health policy results.
Describes how to modify a resource health policy definition.
Describes how to configure your UCP data warehouse.
Describes how to configure utility health policies.
Describes how to adjust attenuation in CPU utilization policies.
Describes how to remove an instance of SQL Server from a UCP.
Describes how to change the proxy account for the utility data collector on a managed instance of SQL Server.
Describes how to move a UCP from one instance of SQL Server to another.
Describes how to remove a UCP.
Describes how to troubleshoot the SQL server utility.
Describes how to troubleshoot SQL Server resource health.
Links to UtilityExplorer F1 Help topics.