...
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 format is:
Code Block |
---|
sqlserver://<username>:<password>@<ip>:<port>?database=sqltelemetrydbipOrDNS,port,username,password,database |
<username>:<password>
: leave this section unchanged<ip>:<port>
: Replace this with the actual IP address and port numberdatabase=sqltelemetrydb
: Replace sqltelemetrydb with the database nameusername,password
: Replace these with the username and passwordipOrDNS: The IP address or DNS of the SQL Server instanceport: 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
)
Run sqlserver-telemetry
Windows
...