Registering Server Instances in Performance Viewer
Before you can view SQL Server performance information, you need to
register the server in Performance Viewer. From the File menu, select
Add Server Registration to open the Server Registration dialog.
Enter the following values in the Server Registration dialog and
click OK:
- SQL Server: Name or IP address of the
server you want to monitor. For example, SQLServ or SQLServ\Instance2
for a named instance
- Windows Authentication or SQL Server Authentication: Select
the method of authentication you want to use to connect to the server.
Remote servers usually require SQL Authentication unless they are on
the same domain.
- Login Name: The login name used to connect
to SQL Server if SQL Server Authentication is used.
- Password: The password used to connect to SQL Server if SQL
Server Authentication is used.
The login account used to connect to SQL Server must belong to the
sysadmin server role. |
