With SQL Diagnostic Manager, monitor the performance of the entire SQL Server environment by quickly and easily adding SQL Server instances. There are two different ways to add instances of SQL Server to SQL Diagnostic Manager. First, you can add instances with the graphical user interface (GUI). You can also add instances through PowerShell. It is easy to add instances to SQL Diagnostic Manager.
The GUI uses a wizard that first shows you which instances are registered. The first step is to specify how you will connect to the SQL Servers. Windows authentication refers to the account that is running the SQL Diagnostic Manager collection service. A non-trusted environment may use a different Windows domain or it may not use Windows authentication. Instead, use SQL Server authentication to connect. And then you have the option to encrypt the connection from the SQL Diagnostic Manager collection service to the instances being monitored.
Watch the 14-minute video “Adding SQL Server Instances with SQL Diagnostic Manager for SQL Server” to learn how to monitor the performance of the entire SQL Server environment by quickly and easily adding SQL Server instances.
SQL Diagnostic Manager for SQL Server is a monitor and advisor tool for SQL Server. It provides database administrators and system administrators with the right metrics to manage and optimize applications during development and production. It provides the tools to manage many SQL Server servers, to tune the database infrastructure, and to aid in finding and fixing problems with database applications before they develop into more serious issues or costly outages.