Utility Explorer works inside of Management Studio, so it uses the same familiar interface that you already know. In Management Studio, to switch to the Utility Explorer, go up to the View menu, and then click on Utility Explorer.

Using the SQL Server Utility application, they can gather information about the status, health and performance of a large number of servers in one centralized location called the “SQL Server Utility”.

The process begins by establishing a utility control point. This is simply a SQL server instance that will serve as the cental hub for data collection from the other servers that will be monitored. Once enrolled, servers will report in and update their status every 15 minutes. The control point gathers this information and presents it in a dashboard, making it easy for the DBA to get the big picture of the health of the enterprise at a glance.

Last modified: March 19, 2019



Write a Reply or Comment