...
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,portportOrInstanceName,username,password,database |
Field | Description | Example Values |
|---|---|---|
ipOrDNS |
...
port: The port on which SQL Server is running
...
username: Username for authentication
...
password: Password for authentication
...
Host address (IP or DNS name) for SQL Server |
| |
portOrInstanceName | Port number or instance name (depends on validity) |
|
username | SQL Server username for authentication |
|
password | Password for the SQL Server username |
|
database | Name of the database to connect to |
|
The tool will use this information to build connection strings to retrieve the necessary data.
Run sqlserver-telemetry
Windows
...