From the course: Designing Database Solutions for SQL Server 2016

Unlock the full course today

Join today to access over 23,300 courses taught by industry experts.

SQL Server utility

SQL Server utility - SQL Server Tutorial

From the course: Designing Database Solutions for SQL Server 2016

Start my 1-month free trial Buy for my team

SQL Server utility

“

- [Instructor] Many data base administrators are often put in charge of monitoring the health of several SQL server instances and application across an entire enterprise. 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. In order to create the utility control point and enroll server instances to be managed, you'll use a graphical interface called "Utility Explorer". Utility Explorer works inside…

Contents