The Add Servers wizard allows you to add the SQL Server instances you want to monitor. The Add Servers wizard also allows you to configure all the common options you use for monitoring SQL Server collection settings and alerts, and apply an alert template.

If you are adding several SQL Server instances and you want to configure the same alert thresholds on each instance, consider setting up an alert template before adding any of your SQL Server instances.

Access the Add Servers wizard

You can open the Add Servers wizard from the SQL Diagnostic Manager Console menu by selecting File > Manage Servers, and then clicking Add in the Manage Servers window.

Other configurations that need attention when adding a virtualized SQL Server instance

If the monitored SQL Server instance you want to add resides on a virtual machine, add the instance using the Add Servers wizard, and then access the VM configuration window to associate the instance with the correct virtual machine and host.

IDERA recommends that you register individual instances in the Add Servers wizard when looking to monitor availability replicas. Note that registering an Availability Group Listener may result in misleading data due to the failovers between availability replicas.

About alert templates

SQL Diagnostic Manager allows you to configure generic alert settings as a template that you can apply to servers and groups of servers in your organization. Click Tools > Alert Configuration Template and complete the required fields to configure an alert template.

Delete a SQL Server instance

You can easily delete a SQL Server instance at any time by right-clicking the appropriate instance, and then selecting Delete. SQL Diagnostic Manager displays a confirmation message that asks, "Would you like to retain the data collected for the selected instance?" Click Yes and SQL Diagnostic Manager retains data for the instance and includes it in some reports, such as the Server Inventory report. Click No and SQL Diagnostic Manager deletes the SQL Server instance and all related data.

SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >