Create a SQL Server Utility Control Point

image

Figure 1 – SQL Server Utility Configuration Steps that show up on the Utility Setup

You may have read my previous post – Solving – WMI Provider Error, and how the issue was solved by creating the Utility Control Point (UCP). 

The Utility Tool has some excellent features that track the health of SQL Server.  So, what do you need to know about it?

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. – from https://docs.microsoft.com/en-us/sql/relational-databases/manage/sql-server-utility-features-and-tasks

The information below describes that an organization can have many SQL Server Utilities. 

An enterprise can have multiple SQL Server Utilities, and each SQL Server Utility can manage many instances of SQL Server and data-tier applications. Every SQL Server Utility has one and only one utility control point (UCP). You must create a new UCP for each SQL Server Utility. Each managed instance of SQL Server and every data-tier application is a member of one and only one SQL Server Utility, and is managed by a single UCP.+

The UCP collects configuration and performance information from managed instances of SQL Server every 15 minutes. This information is stored in the utility management data warehouse (UMDW) on the UCP; the UMDW file name is sysutility_mdw. SQL Server performance data is compared to policies to help identify resource use bottlenecks and consolidation opportunities.  – from https://docs.microsoft.com/en-us/sql/relational-databases/manage/create-a-sql-server-utility-control-point-sql-server-utility 

The listing of requirements and recommendations is list at the same hyperlink noted above.