...
In the directory where you downloaded the application, create a new file called servers.csv with the required details for all of the SQL Server instances you would like to collect data from. This file can be created with Notepad, Excel, or any text editor. Each SQL instance should have its own line, and there is no limit to the number of SQL Servers.
The recommended connection string csv format for each instance is:
| Code Block |
|---|
ipOrDNS,port,username,password,database |
ipOrDNS: The IP address or DNS of the SQL Server instance
port: The port on which SQL Server is running
username: Username for authentication
password: Password for authentication
database: The default database to connect (e.g.,
master)
The tool will use this information to build connection strings to retrieve the necessary data.
Run sqlserver-telemetry
Windows
...