SQL Server Utility Features and Tasks

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.

Benefits of 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.

Getting Started with 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.

Description

Topic

Describes considerations to configure a server to run utility and non-utility collection sets on the same instance of SQL Server.

Considerations for Running Utility and non-Utility Collection Sets on the Same Instance of SQL Server

Describes how to create a SQL Server utility control point.

Create a SQL Server Utility Control Point (SQL Server Utility)

Describes how to connect to a SQL Server Utility.

Connect to a SQL Server Utility

Describes how to enroll an instance of SQL Server with a Utility Control Point.

Enroll an Instance of SQL Server (SQL Server Utility)

Describes how to use Utility Explorer to manage the SQL Server utility.

Use Utility Explorer to Manage the SQL Server Utility

Describes how to monitor instances of SQL Server in the SQL Server Utility.

Monitor Instances of SQL Server in the SQL Server Utility

Describes how to view resource health policy results.

View Resource Health Policy Results (SQL Server Utility)

Describes how to modify a resource health policy definition.

Modify a Resource Health Policy Definition (SQL Server Utility)

Describes how to configure your UCP data warehouse.

Configure Your Utility Control Point Data Warehouse (SQL Server Utility)

Describes how to configure utility health policies.

Configure Health Policies (SQL Server Utility)

Describes how to adjust attenuation in CPU utilization policies.

Reduce Noise in CPU Utilization Policies (SQL Server Utility)

Describes how to remove an instance of SQL Server from a UCP.

Remove an Instance of SQL Server from the SQL Server Utility

Describes how to change the proxy account for the utility data collector on a managed instance of SQL Server.

Change the Proxy Account for the Utility Collection Set on a Managed Instance of SQL Server (SQL Server Utility)

Describes how to move a UCP from one instance of SQL Server to another.

Move a UCP from One Instance of SQL Server to Another (SQL Server Utility)

Describes how to remove a UCP.

Remove a Utility Control Point (SQL Server Utility)

Describes how to troubleshoot the SQL server utility.

Troubleshoot the SQL Server Utility

Describes how to troubleshoot SQL Server resource health.

Troubleshoot SQL Server Resource Health (SQL Server Utility)

Links to UtilityExplorer F1 Help topics.

Utility Explorer F1 Help