...
In the directory where you downloaded the application, create a new file called servers.csv with the connection strings 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. One Each SQL Server instance should be one per 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 |
|---|
sqlserver://<username>:<password>@<ip>:<port>?database=sqltelemetrydbipOrDNS,portOrInstanceName,username,password |
...
<username>:<password>: leave this section unchanged
...
<ip>:<port>: Replace this with the actual IP address and port number
...
database=sqltelemetrydb: Replace sqltelemetrydb with the database name
...
,database |
Field | Description | Example Values |
|---|---|---|
ipOrDNS | 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
...